Hi all, I'm looking for a code to be able to hide different rows on 2 different sheets in a workbook. I have the code to hide/unhide on the first sheet and assigned to a button, but I cannot figure out how to expand the code to hide rows on the next sheet. basically I'm trying to hide seasonal categories when not needed. i have attached a sample workbook. any help figuring this out would be greatly appreciated.
Hi,
You just need to specify what sheet you want to hide the rows for like this:
Please Login or Register to view this content.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
thanks for taking a look, but how to combine the 2 sheets together? I'm using < 'Sub sbHidingUnhideRows()
'To Hide Rows 15 to 18> as part of my code, when I put your code in I get Run-time error '1004", Unable to set the Hidden property of the Range class, when I go to debug your code is highlighted. I'm not good with VBA at all, ha ha as you can tell.
Hi,
No problems. Your issue is that you need to unprotect the second sheet i.e.
In most cases you should try and reference your sheet rather than using "ActiveSheet" so then it doesn't matter what sheet you are in you can still run the code.Please Login or Register to view this content.
I have amended the macros on the attached workbook using a With statement like this:
Please Login or Register to view this content.
thanks a ton spitfireblue, works great. reputation added.
hi spitfire, thanks again for helping me with this way back, but i had to add some pages in this workbook and need to hide rows on other pages, but when i add to the code i get a Run-time error '9' subscript out of range. any ideas? i took the above code and added another with sheets line (just like line 2), when i go to debug it takes me to the third sheet prod variance. basically how can i manipulate this code for say 4 to 5 sheets? i dont have any variables, besides wanting to hide/hunide categories and the above code works great for just the 2 sheets listed above. each sheet does have some different row numbers that i put in.
The "Subscript out of range" means that you've got the names inexact - it's often a space in the name either in the code or in the sheet name
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks