|
-
Sep 15th, 2009, 08:42 PM
#1
Thread Starter
Hyperactive Member
Re: Hiding sheets based on their Tab name
Sid, I took a look at that example, and no that's not quite right. I appreciate your help though. I made an Index sheet, that has a list of all the sheets in the Workbook in Col A. I just made a drop down list in the middle of the page (like you did in the Example), and made acquired a code that when the Drop down is empty it comes up with a box saying pick a sheet. I finally got an all command that when "ALL" is in the Drop down ALL sheets in the Workbook are Visible. And Finally, whatever sheet is in the Drop down is Visible and all others Except the Index (Index is always shown) is Hidden. So now I have where only one sheet is shown at a time. I am trying to figure out how to have 4 sheets shown at a time being the last 4 sheets selected in the Drop Down. My thinking was to have the Macro ignore the first 4 sheets in the workbook (Left to Right Index being the First sheet) Sheets2,3,4,5 are ignored when the Macro goes through it's code. Every sheet that is in the Drop Drop down and is Selected Visible is Moved to the Sheet2 slot. So that gives me my history of 4 Sheets Visible.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|