enabling macros on shared workbooks Closed

Question

Hello, 

is there a way to share a workbook with macros or VBA codes??

Thanks......


Configuration: Windows XP / Firefox 3.5.11

rizvisa1 · Answer

I was not aware there is any limitation as such. do you get some issue ?

SARC · Answer

yes,,,.. when I share the workbook so that mulitiple people can work on it the same time it says that vba cant be done while shared.. my code  involves protecting and unprotecting sheets automatically maybe thats the issue. because after u share a workbook u cant unlock the sheet or lock the sheet until u take the workbook out of the share

Petros · Answer

Here is what you have to do to unlock macros in shared workbooks:

http://www.spreadsheet1.com/move-excel-vba-projects-from-one-workbook-to-another.html

Petros · Answer

If you want to write to protected sheets with VBA, protect sheets programmatically with UserInterfaceOnly:=True

Do not protect sheets manually from the Review tab

Enabling macros on shared workbooks

4 responses

Similar discussions

Subscribe To Our Newsletter!