A Alberto Ast Oct 23, 2009 #1 I want to run macros on a share file but it is not working.. How do I do it?
G Gord Dibben Oct 23, 2009 #2 What is "not working"? Nothing? Errors? You can normally run macros on a shared workbook. You just can't access the code through VBE or see macros in the Macros dialog.. Post your code. Your code may be trying to do something not legal, like unprotect a worksheet. Gord Dibben MS Excel MVP
What is "not working"? Nothing? Errors? You can normally run macros on a shared workbook. You just can't access the code through VBE or see macros in the Macros dialog.. Post your code. Your code may be trying to do something not legal, like unprotect a worksheet. Gord Dibben MS Excel MVP
G Gord Dibben Oct 23, 2009 #4 None that I know of. Type "shared" into help and click on "Features that are unavailable in shared workbooks" Has a list of unavailable features and some workarounds. You will see that sheet protection cannot be changed. Gord
None that I know of. Type "shared" into help and click on "Features that are unavailable in shared workbooks" Has a list of unavailable features and some workarounds. You will see that sheet protection cannot be changed. Gord
