HotNumbers
Well-known Member
- Joined
- Feb 14, 2005
- Messages
- 732
How do i check to see if a sheet is hidden if so Unhide it if not Hide it? Hide or Unhide
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Hide and UNhide Sheet (True/False)
- Thread starter HotNumbers
- Start date
Excel Facts
Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
HotNumbers
Well-known Member
- Joined
- Feb 14, 2005
- Messages
- 732
Thanks... i understand and appreciate what you pointed out
Upvote
0
Rick Rothstein
MrExcel MVP
- Joined
- Apr 18, 2011
- Messages
- 38,527
- Office Version
- 365
- Platform
- Windows
True enough, although I assumed (probably a bad thing for me to doA user can set sheets to normal Hidden, so I would think it's prudent to take that into account...
Now at least he is aware he can get in trouble
) he was not giving the user access to the toggle code (reserving the functionality for himself only). However, if the user could do what you suggest, then I think this modification to my one-liner would avoid any issues...
Code:
Sheets("Basics BW").Visible = 1 + 2 * (Sheets("Basics BW").Visible = 0) - Sheets("Basics BW").Visible
Upvote
0
Similar threads
- Solved
- Solved
- Question
