Enabling macros on shared workbooks [Closed]

Report
Posts
29
Registration date
Saturday August 7, 2010
Status
Member
Last seen
August 31, 2010
-
 Petros -
Hello,

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

Thanks......


4 replies

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