I need help creating a macro that will hide and unhide rows when the macro button is clicked. I need to hide rows 11 through 28 if column "I" is blank. I would like to add the macro button to be able to hide the rows that do not have a value in column "I" but if rows need to be adjusted click the macro button to show all rows. If it is possible to make the macro to work for all sheets between the tabs labeled First and Last that would be a great bonus. Any help would be greatly appreciated.
Try the below code…
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
A for each approach with external calls via ActiveX Toggle Button.
1. Copy and paste the following (all of it) into a standard module.
2. Create your button by drawing an ActiveX toggle button (Developer Tab > Controls Group > "Insert" > ToggleButton) onto the worksheet in your preferred location.Please Login or Register to view this content.
3. Right-click the toggle button > View Code.
4. Copy and Paste the following between the auto-created (by Excel) "Private Sub" and "End Sub":
5. Deactivate "Design Mode" (also on the Developer Tab in the Controls Group)Please Login or Register to view this content.
Last edited by AlvaroSiza; 10-22-2013 at 01:45 AM.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Hi, aaron061883,
based on the first code maybe
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Holger,
Would your code still hold in a situation where the "First" and "Last" sheets are not actually the left-most and right-most worksheets in the workbook?
#learning
Yes that is the case as the first tab is actually the 6 tab in the workbook
Solved I am not sure how to add the solved feature to the post
Hi, AlvaroSiza,
not a big thing to alter in the code:
@aaron061883:Please Login or Register to view this content.
Ciao,Originally Posted by FAQ
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks