Using macros in a second user account

K

Ken W

I created macros and saved them in the personal workbook. I then created a
second user. When I open Excel in this second user account, my macros are no
longer available. However, I want to be able to use those macros for either
user account. Any suggestions?
 
A

Allllen

in the first account
open excel
tools>macro>visual basic editor
in the project window (usually on the left, look for the book called
personal.xls)
expand it
you should see that it contains some modules. you need to right click on
these and export file. export as .bas on a shared drive somewhere.

for the second user account
1) create a personal macro workbook. Do this by Tools>Macro> record and
saving in personal workbook. record something then stop.
2) tools>macro>visual basic editor
3) look in the personal macro workbook like before. Right click and remove
the modules you have just created.
4) right click and import the modules that you saved as .bas.
 
B

Bob Phillips

Darn, meant right, even worse <BG>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

Now I replied to the wrong thread?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top