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
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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