LinkBack URL
About LinkBacks
Hi all,
How can I adjust below code to have the sheets "DTC", "CK", and "KA" hidden (not very hidden) and every other sheet visible BUT the sheet "Warning". The sheet "Warning" should be very hidden.
Please Login or Register to view this content.
Hi all,
How can I adjust below code to have the sheets "DTC", "CK", and "KA" hidden (not very hidden) and every other sheet visible BUT the sheet "Warning". The sheet "Warning" should be very hidden.
Please Login or Register to view this content.
ps you should probably not call it showallsheets anymorePlease Login or Register to view this content.
Last edited by humdingaling; 05-06-2018 at 10:47 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
It hides the sheets "DTC", "CK", and "KA" successfully. Unfortunately is does not seem to work for the second case.
The sheet "warning" is still visible (tried with several other sheets). What am I missing here?Please Login or Register to view this content.
good call outps you should probably not call it showallsheets anymore
ah wait... is it because of the UCase function? some sheet names are obviously not upper case.
UCase(Sh.Name) makes all the sheets Upper case
so when you make it go against select case statement you know what to match it against
which then makes me think
why is your code written
instead ofPlease Login or Register to view this content.
change this and try againPlease Login or Register to view this content.
Yup. That was it! Also tried without the UCase function
which also works, but I agree that the UCase function gives less room for spelling errors.Please Login or Register to view this content.
Thanks for your help!
UCASE is there as a catch all to stop the thing malfunctioning if someone changes the sheet name from "Warning" to wArning or WARNING or warning etc
you can use LCASE or even PROPER
though i would steer away form PROPER as its the easiest to misalign
okay. Good to know the other options. Will use UCase then
Thanks for the rep
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks