Hi all,
I have two workbooks with approximately 40 tabs on one and 20 tabs on the other. I'm looking for a way to keep these separated, but also have them in the same workbook. So I'm thinking macro buttons that would show all tabs for workbook 1 when clicked, and show all tabs for workbook 2 when clicked.
Any input or ideas to organize these tabs so they are not all just at the bottom row would be appreciated. (Excel 2010)
Thank you
This is a VBA question, so it has been moved to the correct forum.
A button that shows one set of sheet tabs and hides others? Simple enough:
Please Login or Register to view this content.
Adjust that as needed and as many as needed. Remember to always SHOW the tabs first, then hide the rest.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Why not just copy all the worksheets from one workbook to the other and colour the tabs so that the worksheets are visually separate but in the same workbook.
In one of the workbooks select all the worksheets, right click on the selected tabs and click on Move or Copy, select copy (to leave the workbook as is in case something happens in the process) choose where to put the copy in the other workbook and click ok. The selected worksheets will be copied to the other workbook. Then just colour the tabs to make those copied worksheets stand out.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
They are trying to manage how many sheet tabs there are visible at any one time to minimize scrolling. 60 tabs is a lot.
Is it possible to have the functionality so we don't have to "Show" first each time. So for instance, if I click the First Set Button, it hides the second set and quickly after I click the second set button, and it hides the first set button and unhides the second?
Thanks!
You can't HIDE all the sheets first as that might create a scenario where ALL the sheets were trying to be hidden at once. So you must unhide at least one sheet at the start. But you can hide and unhide the rest of the sheets in any manner you want.
Also, the macro technique I showed will be relatively instantaneous. When you click the button all 60 sheets will update visibility pretty fast.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks