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

PT

You would open your Personal.xls and goto windowHide. 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

"PT" wrote:

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

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 wrote:

PT

You would open your Personal.xls and goto windowHide. 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

"PT" wrote:

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




--

Dave Peterson

Dave Peterson

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

Mike Rogers

"Dave Peterson" wrote:

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 wrote:

PT

You would open your Personal.xls and goto windowHide. 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

"PT" wrote:

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




--

Dave Peterson