Sharing Workbook with Macros

Is it possible to share a workbook with macros and have the macros work properly. I have one spreadsheet that needs to be shared by many users. We want to all be in the same document at the same time saving changes. The real catch is that the workbook has macros. I used the 'Share Workbook' function under tools. At the end of the setup, it told me that the macros would not work properly. The odd thing is that everytime I try to click on one of the macros I get an error, but yet the macro still performs the function. So essentially the macro works, it is just a pain because you have to click 'end' everytime on the error screen. Any suggestions?

Alanda

Good afternoon alanda

Macros should work perfectly well in a shared workbook : the only catch is you can't edit macros while the workbook is shared. If you want to amend the macros you must unshare the workbook.

However, there are a number of features that won't work in a shared workbook (for example worksheet protection) and it could be one of these that causes the error.

Search Excel help for "Features that are unavailable in shared workbooks", or post back listing what your macro does for someone to point it out (if you want to post your code you'll have to unshare the workbook to access it).

HTH

DominicB

Hi alanda

With a shared workbook, any existing protection remains in place, but you cannot set protection or unprotect a range.

I know it's restrictive and limiting but those are the limits of shared workbooks...

HTH

DominicB