tom88Excel
New Member
- Joined
- Sep 29, 2014
- Messages
- 30
Hi all,
I wonder why my VBAProject Explorer shows some worksheet that does not exist in my workbook...
What when wrong? I'm sure no sheet is hidden..... I see Sheet1 (Sheet1) thru Sheet5 (Sheet5) on this explorer and I can't find these spreadsheets in my workbook...
Also I have one sheet changed icon to the "ThisWorkbook" icon and the properties became "ThisWorkbook" properties. I notice the Private Sub codes on this sheet had transferred to another sheet and get renamed with a "1" afterward. (Example: APPLE became APPLE1). What caused this to happened?
Thank you for reading please help
Tom
I wonder why my VBAProject Explorer shows some worksheet that does not exist in my workbook...
What when wrong? I'm sure no sheet is hidden..... I see Sheet1 (Sheet1) thru Sheet5 (Sheet5) on this explorer and I can't find these spreadsheets in my workbook...Also I have one sheet changed icon to the "ThisWorkbook" icon and the properties became "ThisWorkbook" properties. I notice the Private Sub codes on this sheet had transferred to another sheet and get renamed with a "1" afterward. (Example: APPLE became APPLE1). What caused this to happened?
Thank you for reading please help
Tom
