Macros with shared workbooks

  • Thread starter Thread starter Frank Haverkamp
  • Start date Start date
F

Frank Haverkamp

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?
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shared Workbook Crash 0
auto_close give me additional information? 4
Unwanted workbooks on startup 2
Visual Basic in a shared workbook 4
Macro can not unprotect a sheet in a shared workbook 4
Protection Macro Causes All Workbooks to Be Locked 12
forcing specific sheet opening upon launch of .xlsx file 4
Hidden macro 3

Back
Top