Multiple users running macro from personal.xls

T

TP

I have noticed that if I add an item to the standard menu bar, that item is
still there when another person logs in to that computer. Now, I want to
attach a macro to that item that will run from personal.xls. Anyone that
sits at that computer will have a personal.xls that resides in the same
location.

My question is, if I set it up when I am logged in and attach it to run a
macro from my personal.xls, when the next person logs in, will that macro
automatically run from _their_ personal.xls, or will it look for mine and
choke?

I am assuming that since the path will be the same, it will run the macro
the personal.xls of the person logged in, but want to be sure I am not
setting us up for problems.

TIA,

Patti
 

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

Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Need Help with Macro Security 1
Digitally Signed Macros in Personal.XLS 3
Where to put PERSONAL.XLS 3
Can I mass-change macro paths of tool buttons? 15
Accessing the PERSONAL.XLS without a macro ever recorded by user. 3
Call Macro from PERSONAL.XLS 4
Macros in PERSONAL.XLS 1

Top