Excel 2007: question on macro and XLSStart

[Daniel]

Hi everybody,

I have created a macro (thanks to the help I got from this NG) and I would
like it to be available in every worksheet I open. Right now, it is only
available in the particular worksheet that was open when I created it.

How can I do this?

I found this folder named XLSStart. I was wondering if It could be a good
idea to create again my macro in a specific worksheet (that I could name for
example "mymacros.xls") and save this worksheet in the xlsstart folder. I
tried to do this but I got an error message saying something like I was not
authorized to access this folder, and I had to contact the Administrator.
But I am the Administrator...

Why did I get this message? What Ihave I got to do to be able to save files
in that folder?

And, in the first place, is it the best way to put a worksheet with my macro
in that folder so that it can be executed in every worksheet I open?

(sorry about my English). Anyone?

many thanks in advance for your kind help.

with Brgds,
Daniel

 

[Bernard Liengme]

You need to place the subroutine in a file called Personal stored in XLSTART
folder - read Help and then come back if you have questions

 

[Daniel]

Many Thanks, Bernard.

I managed to save the file in the XLSTART folder, and it works.
brgds,
Daniel