View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Shared Worksheets w/VBA

Hi
you can't change macros then the workbook is in the shared
mode.

-----Original Message-----
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

.