Enabling macros on shared workbooks

Closed
SARC Posts 29 Registration date Saturday August 7, 2010 Status Member Last seen August 31, 2010 - Aug 18, 2010 at 05:23 AM
 Petros - Dec 14, 2014 at 02:12 PM
Hello,

is there a way to share a workbook with macros or VBA codes??

Thanks......


4 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 18, 2010 at 07:47 AM
I was not aware there is any limitation as such. do you get some issue ?
0
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
0
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
0
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
0