Personal.xls stays open

[Alex Delamain]

Boosted by all I have learned in here I have started experimenting wit
macros and VBA.

My first macro was saved into Personal.xls which now opens every time
open excel instead of a blank spreadsheet. However I have just seen
reference that says Personal.xls should open and then hide itself.

How do I get it to do that

 

[Jim Rech]

However I have just seen a reference that says Personal.xls should open
Actually it should just open hidden. To achieve that you have to save it
with all its windows hidden. First make it the active workbook in Excel.
Then use Window, Hide to hide all of its windows. Next flip over to the VBE
and select Personal.xls in the Project Explorer. And finally click the Save
toolbutton on the VBE standard toolbar.

--
Jim Rech
Excel MVP
message |
| Boosted by all I have learned in here I have started experimenting with
| macros and VBA.
|
| My first macro was saved into Personal.xls which now opens every time I
| open excel instead of a blank spreadsheet. However I have just seen a
| reference that says Personal.xls should open and then hide itself.
|
| How do I get it to do that?
|
|
| --
| Alex Delamain
| ------------------------------------------------------------------------
| Alex Delamain's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=11273
| View this thread: http://www.excelforum.com/showthread.php?threadid=270098
|