Personal macro workbook

[Paul Skinner]

Running excelX, Panther 10.3.7
Is there a way to have a separate Personal macro workbook For each user.
Other users running macros have access to my Personal Macros which I use
In different workbooks.
Paul

 

[JE McGimpsey]

Is there a way to have a separate Personal macro workbook For each user.
Other users running macros have access to my Personal Macros which I use
In different workbooks.

Instead of putting your Personal Macro Workbook (which can be called
anything) in the

HD/Applications/Microsoft Office 2004/Office/Startup/Excel

folder, put it in a convenient folder in your home directory (mine are at

~/Library/Application Support/Microsoft User Data/Startup/Excel

but your MUD folder is probably in ~/Documents).

Now, in Preferences/General, enter (or browse to) that directory in the
Alternate Startup Folder field.

Each user should do the same. No other user will see your alternate
startup folder, since its path is stored in your personal preferences.

 

[Paul Skinner]

Instead of putting your Personal Macro Workbook (which can be called
anything) in the

HD/Applications/Microsoft Office 2004/Office/Startup/Excel

folder, put it in a convenient folder in your home directory (mine are at

~/Library/Application Support/Microsoft User Data/Startup/Excel

but your MUD folder is probably in ~/Documents).

Now, in Preferences/General, enter (or browse to) that directory in the
Alternate Startup Folder field.

Each user should do the same. No other user will see your alternate
startup folder, since its path is stored in your personal preferences.

Good one! Thanks once again