Excel Macros & Personal.xls

[PT]

Excel 2003 - I used to know how to do this, but have lost the procedure.
Here's the question:

I have a worksheet Personal.xls located in the folder Docs & Settings \ User
\ Application Data \ Microsoft \ Excel \ XLStart

I want it to become a hidden worksheet in my default worksheet, so the
macros will always be available.

What are the steps to do this?

 

[Mike Rogers]

PT

You would open your Personal.xls and goto window>Hide. This will hide it so
it will open in a hiden condition when an instance of excel is open, thus
making all macros available.

HTH

Mike Rogers

 

[Dave Peterson]

Just to add to Mike's response.

After you hide the window, close excel.

You'll be prompted to save your changes to personal.xls (since you hid it).
Answer yes.

 

[Mike Rogers]

Dave Peterson

Thanks Dave, complete responses can be a bit more helpful <g>

Mike Rogers