LinkBack URL
About LinkBacks
Hi,
I have a worksheet with multiple sheets and I need help with a Macro to be able to hide & unhide specific sheets...
Thanks
Hi,
I have a worksheet with multiple sheets and I need help with a Macro to be able to hide & unhide specific sheets...
Thanks
On what basis do you want to Hide/Unhide sheets?
Cheers!
Deep Dave
This workshhet needs to be uploaded into a webpage but only require specific sheets. I just want speed up the process to hide these sheets instead hiding one by one.
Thanks
No No.. How do you decide which Workbooks to hide?
Let say I have sheet1,sheet2,sheet3,sheet4,sheet5 but just want to keep showing sheet4 & sheet5
Hi, Zorro9758,
maybe
But I would go the other round and copy only those sheets you want to upload to a new workbook.
Sheets(Array("Sheet1", "Sheet5", "Sheet7")).Visible = False
CIao,
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
Do you have a macro where I can copy those specific sheets into new worksheet?
Hi, Zorro9758,
just like
This will copy Sheet4 and Sheet5 to a new workbook.Sheets(Array("Sheet4", "Sheet5")).Copy
Ciao,
Holger
Great than you for you help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks