View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TP[_3_] TP[_3_] is offline
external usenet poster
 
Posts: 5
Default Multiple users running macro from personal.xls

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