Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Worksheets w/VBA
I'm not trying to change the macros. Users aren't able to make changes and
save the workbook in SHared mode with there being Macros in the spreadsheet. The macros serve functions and are intended to be use by whoever is in the shared workbook. But when someone makes a change to the workbook they are unable to save their changes unless the work book isn't in shared mode. Kirk "Frank Kabel" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting chances in shared worksheets | Excel Worksheet Functions | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
Help merging worksheets in shared workbook | Excel Discussion (Misc queries) | |||
conflicting users in shared worksheets. | Excel Discussion (Misc queries) | |||
Worksheets Vanishing in Shared Workbook. | Excel Discussion (Misc queries) |