Enabling macros on shared workbooks [Closed]

Posts
29
Registration date
Saturday August 7, 2010
Status
Member
Last seen
August 31, 2010
- - Latest reply:  Petros - Dec 14, 2014 at 02:12 PM
Hello,

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

Thanks......


See more 

4 replies

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
753
0
Thank you
I was not aware there is any limitation as such. do you get some issue ?
0
Thank you
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
Thank you
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
Thank you
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