Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

"Missing" sheet!

Posted by Martin Maatman Oonk from Holland on January 28, 2002 4:36 AM

Dear Mr. Excel,

I'm going stir crazy!!!

If I record a macro in my Personal MacroWorkbook I get:
VBAProject (Persnlk.xls).

Then I get Microsoft Excel objects en Modules,
in Microsoft Excel objects there is the sheet:
Sheet1 (Sheet1).

Where is that sheet in Excel???
I see it in the VB-editor, but I don't see it in Excel!
How can I type data on this sheet.

Will you help me and know you can!

Best regards,

Martin J.A. Maatman Oonk

Re: "Missing" sheet!

Posted by Ivan F Moala on January 28, 2002 4:42 AM

By default your Persnlk.xls file is hidden from view.
To view it goto Window > Unhide
Select the Persnlk.xls file here to unhide it.

HTH

Ivan

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.