I have a xlsm on SharePoint that the user's select and open (often they work in the template first and later save to their PC's if they decide to)..
so the "Server Read-Only this workbook was opened from a server in read-only mode Edit Workbook" defaults at the top of the of the sheet.
all the macros work...except one that i added that opens other sheets (for subsquent calculations)...
'... Worksheets("a").Visible = True 'works Worksheets("b").Visible = True 'works Worksheets("c").Visible = True 'doesn't work (Error message - but i do see the tab name, when i stop the code (debug) and right click on a worksheets tab (right click and i can manually unhide '...
i'm not sure what the cause may be (when I enable, all the macros work)...?