Shared Worksheets w/VBA
 

What happens when they try to save the workbook with macros?

Do they get an error message?

There was a post recently that the developer of the shared workbook disabled the
Save option for his shared workbook (for some users).

The user reset his toolbar and was able to save.





Kirk wrote:

I have a client that has an issue with using a shared workbook that has VBA
code within it.

When it is in the Shared Workbook mode, people are unable to save changes.
Which means the only way for people to utilize the spreadsheet is to turn off
the Shared Workbook, which defeats the purpose.

Any ideas as to why this is happening? Any solutions? Client is running XP
Professional and Excel 2002.

Any help would be appreciated. Thanks.

Kirk

--

Dave Peterson