Hello,
I have Excel 2010. I am new to VBA. I tried the "record a macro" function, but was unable to get it to do what I want. I am trying to write a macro to hide a worksheet if C$3="" in that worksheet. There are about 23 different sheets, and I am having trouble coding it. I would greatly appreciate any insight you may have.
Open the vba editor and find the sheet(s) you want this to happen on in the top left window. Right click it and select 'view code' and paste this in:
Please Login or Register to view this content.
Hello Schwartz,
The basic VBA statement would be. There are other methods but to know which one is best for your needs would require more information.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you for the quick replies. Let me clarify exactly what I need. I apologize I did not specify earlier. The macro needs to Look at C3 of each sheet. If there is no value in C3, it needs to hide that sheet. If there is a value, It needs the tab to be renamed to the value in C3. I have the code to change the tab name, but I do not know how to incorporate the hiding function.
Please Login or Register to view this content.
Last edited by Schwartz; 01-23-2012 at 05:04 PM.
Thank you for the quick replies. Let me clarify exactly what I need. I apologize I did not specify earlier. The macro needs to Look at C3 of each sheet. If there is no value in C3, it needs to hide that sheet. If there is a value, It needs the tab to be renamed to the value in C3. I have the code to change the tab name, but I do not know how to incorporate the hiding function.
Please Login or Register to view this content.
Last edited by Schwartz; 01-23-2012 at 05:09 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks