Activate Macro/vba for a shared workbook

[JCHuysamer]

Hi All

Is there any way to keep your Macro's (VBA) enabled on a shared workbook???<strike></strike>

 

[elmer007]

I think they're enabled on a shared workbook, you just can't create, view, or modify them (so be sure that they function properly before sharing).

 

[JCHuysamer]

so how do you run a user form in a shared workbook??

 

[elmer007]

How is it being shown in the unshared book? You can either put a button on the sheet or give the macro a shortcut key to run from the keyboard (like CTRL+SHIFT+D)

The button's code would be:

UserForm1.Show

To assign a keyboard shortcut, go to the Developer tab on the ribbon and click "Record Macro," give it a shortcut in the window that pops up, click "OK," then click "Stop Recording." This will give you a blank sub that runs from a shortcut, and the code for the sub can be UserForm1.Show .

 

[JCHuysamer]

The form is run from a Commandbutton

I have created a work around

created a master data file
everytime someone opens the file on their computer it copys all the data from the master file and when they save it pastes the new info back to the master file

but thanks anyway