sharing macro's

  • Thread starter Thread starter frontdesk
  • Start date Start date
F

frontdesk

Our office is networked and we need to be able to share
macros, I would like to know if it is possible to share
macros on a form that is available to our network system.
I have made the necessary macro on my computer but noone
else is able to utilize them.
 
Our office is networked and we need to be able to share
macros, I would like to know if it is possible to share
macros on a form that is available to our network system.
I have made the necessary macro on my computer but noone
else is able to utilize them.
Click to expand...

The following approach works for me.

Create the workbook containing the macros and forms. Save a copy in a personal
directory as an unhidden workbook. With the workbook open, save a copy in a
shared directory then hide the workbook (Window > Hide), and save it again
(switch to the VB Editor, and save it there). Close that copy of the file, then
make it read-only.

Put a *shortcut* to the file in the shared directory into each user's Autoload
directory.

That done, whenever a user runs Excel, Excel will load the hidden, read-only
copy of the workbook from the shared directory. Of course, users would need to
have macros enabled for this to do anything for them other than waste RAM.
 
Back
Top