Excel Macros & Personal.xls

  • Thread starter Thread starter PT
  • Start date Start date
P

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?
 
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
 
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.
 
Back
Top