Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros with shared workbooks
I know there must be a good reason, but why can't I use the macros or
VBA code I've written when I ste the workbook to shared? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros with shared workbooks
Hi Frank,
You can _use_ the VBA code, you just can't view or edit it after you share the workbook. If you need to view/edit the code in the future, you can always unshare it, modify the code, then reshare it. Better yet, use an add-in for all of your code, and the shared workbook can simply be a "template" that the add-in uses. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] I know there must be a good reason, but why can't I use the macros or VBA code I've written when I ste the workbook to shared? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared workbooks | Excel Discussion (Misc queries) | |||
Macros in shared workbooks | Excel Discussion (Misc queries) | |||
Shared Workbooks-shared headers and footers | New Users to Excel | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
Shared Workbooks | Excel Worksheet Functions |