Personal macro workbook

P

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
 
J

JE McGimpsey

Paul Skinner said:
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.
Click to expand...

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.
 
P

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.
Click to expand...

Good one! Thanks once again
 
Top