- Open the visual basic editor (Hold Alt and press F11)
- In the project tree on the top left, expand “Microsoft Excel Objects” and click on the sheet you want to hide.
- In the property window for the selected sheet (you may have to open it from the main menu)
- There is a combo box in the Visible property, set it to “xlSheetVeryHidden” (See image below).
No comments:
Post a Comment