macro on share files

  • Thread starter Thread starter Alberto Ast
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
Running Macros in a Shared File 2
Sharing Macros 1
Sharing xls file with macro (xlsm) 0
security, enabling macros to enable a disabling saving function 12
Word VBA to update cross-referencing 0
Macro can not unprotect a sheet in a shared workbook 4
How to ??? 1

Back
Top