Macro

[nfpk]

Hi!
Anyone knows where macros in Excel are stored.
I know that there are different levels.

Macros or modules on Sheet level.
Macros or modules on workbook level.

But if I want to make a macro available for all Workbooks I save it in "MyOwn Macros" (maby not the right terminologi in english but I hope you understand what I mean).
Where is this stored?
Is it in the same place as Xlstart or???

nfpk

 

[DrSimon]

They are held in a hidden workbook called 'Personal.xls'. This is normally the default. If you ever want to look at or edit an existing macro, you will need to Unhide it (Use Window / Unhide)

Simon Rouse

 

[nfpk]

Is it possible to change the path to the directory where peronal.xls is stored?

nfpk

 

[DrSimon]

Not that I'm aware of. It goes into your default Excel directory - the point is that it is a PERSONAL sheet and thus not shared with others.

 

[xlbo]

The other point is that it needs to start whenever excel is started - anything in the XLSTART fodler will be opened when excel is. Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[nfpk]

Well my problem is that in my company, we use a citrix solution where we logon and start excel from four different Citrixservers, which one you login to depends on the number of users at the moment. This means that Xlstart is situated on four different servers, so I hav to save my personal macros at least four times to be sure they are available when I want them. Often one server is reinstalled which means Xlstart is empty again and I have to start all over again. So I want to change the path to Xlstart to another server or to my harddrive, but still get the program from the Citrix server. Is this possible?
nfpk