Excel Macros & Personal.xls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PT - 26 Apr 2007 00:56 GMT

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?

Signature

Reply to this Message

Mike Rogers - 26 Apr 2007 01:12 GMT

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

> Excel 2003 - I used to know how to do this, but have lost the procedure.
> Here's the question:
[quoted text clipped - 6 lines]
>
> What are the steps to do this?

Reply to this Message

Dave Peterson - 26 Apr 2007 02:38 GMT

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.

> PT
>
[quoted text clipped - 19 lines]
> > --
> > PT

Signature

Dave Peterson

Reply to this Message

Mike Rogers - 26 Apr 2007 03:32 GMT

Dave Peterson

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

Mike Rogers

> Just to add to Mike's response.
>
[quoted text clipped - 26 lines]
> > > --
> > > PT

Reply to this Message