to do this i have to unprotect and reprotect various sheets from within the vb. The user makes some selections and pushes a button, and then behind the scenes the vba goes to essbase and pulls in a bunch of data based upon the users selections. user the click the link again to the open the file and modifies it. symptoms: user can check out the document (check out done to the local draft). scenario 2: unable to check in back documents. click the file in read only mode and check out to edit, opens in read only mode.
#Excel for mac open new workbook how to
How To Remove Or Disable Read Only In Excel File Xls XlsxĬlick on file directly and click check edit, opens as read only. in the file passwords dialog box, select the read only recommended check box, and click ok. click the file menu, and then click passwords. excel details: open the workbook you want to protect. please note that lsof is executed as the superuser. use terminal with ls(1) and lsof(8) to tell whether any lock related file is present for the affected workbook and to tell whether anything other than excel has the workbook open. Other causes of excel treating a workbook as read only. choose “ tools ” > “ general options ” at the bottom of the window. ensure the file format box is set to “ excel workbook “, then select “ more options…. in excel, select “ file ” and click save as. Follow these steps to set the file to display the “open as read only” prompt. open the workbook that you want to protect. the next time the workbook is opened, a message will ask if you want to open as read only. a subscription to make the most of your time.
on the review tab, under protection, click passwords. Open the workbook that you want to protect.
0 kommentar(er)
