Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How use info in Excel shared worksheets to create new worksheets dkc Excel Worksheet Functions 0 June 28th 07 08:36 PM
Help merging worksheets in shared workbook Smilingout_loud Excel Discussion (Misc queries) 0 December 27th 06 09:55 PM
conflicting users in shared worksheets. nightcrawler.36 Excel Discussion (Misc queries) 0 July 28th 06 05:37 PM
Worksheets Vanishing in Shared Workbook. guilbj2 Excel Discussion (Misc queries) 0 November 29th 05 02:42 PM
Shared Worksheets w/VBA Frank Kabel Excel Programming 1 September 20th 04 07:29 PM


All times are GMT +1. The time now is 03:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"