It’s real tough for a user to manipulate a worksheet when they can’t see it…try this.
1. Put this in a module
Sub SheetUnhide() Sheet1.Visible = xlSheetVisible End Sub
Leave a Comment
Search Posts
Categories
- Books (5)
- Charts (17)
- Data (17)
- Excel.mod (16)
- Formatting (30)
- Formulas (58)
- Games (7)
- General (35)
- Misc (66)
- News (29)
- Shortcuts (33)
- Sites (34)
- Templates (23)
- VBA (134)
- Cells, Columns & Rows (19)
- Strings (10)
- Worksheets (8)
- VSTO/DotNet (2)
- XML/Services (38)
What do we do?
Pages
Some Stats
Visits today: 1170Users Online: 18