ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple users running macro from personal.xls (https://www.excelbanter.com/excel-programming/275062-multiple-users-running-macro-personal-xls.html)

TP[_3_]

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








All times are GMT +1. The time now is 04:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com