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?

in the first account
open excel
toolsmacrovisual 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 ToolsMacro record and
saving in personal workbook. record something then stop.
2) toolsmacrovisual 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.


--
Allllen


"Ken W" wrote:

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?

Darn, meant right, even worse <BG

--
HTH

Bob Phillips

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

"Ken W" wrote in message
...
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?

Now I replied to the wrong thread?

--
HTH

Bob Phillips

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

"Bob Phillips" wrote in message
...
Darn, meant right, even worse <BG

--
HTH

Bob Phillips

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

"Ken W" wrote in message
...
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?