Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide and unhide worksheets when a set button on a form is clicked
hi everyone,
the link from the e-mail sent does not show the reply to the problem is sent earlier which is: i have aworkbook with 4 worksheets and a user form with 4 buttons, what i would like to do is have the 4 buttons hide various worksheet tabs when clicked by the user. button 1 would show sheets 1 and 2. button 2 would show sheets 1 and 3. button 3 would show sheet 1. button 4 would show sheets 1 and 4. if the person who replied first time could re-send the answer as my question is not comming up when i search for it. many thanks Dave ferris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide and unhide worksheets when a set button on a form is clicked
When you VIEW CODE on the first button, the code would be: Code: -------------------- Sheet1.VeryHidden = False Sheet2.VeryHidden = False Sheet3.VeryHidden = True Sheet4.VeryHidden = True -------------------- Bet you can figure the others out now. (wink) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44676 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide and unhide worksheets when a set button on a form is clic
many thanks for the quick reply sorry about the delay in replying but i have
only just managed to see my ownpost let a lone your reply. thank you "JBeaucaire" wrote: When you VIEW CODE on the first button, the code would be: Code: -------------------- Sheet1.VeryHidden = False Sheet2.VeryHidden = False Sheet3.VeryHidden = True Sheet4.VeryHidden = True -------------------- Bet you can figure the others out now. (wink) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44676 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide and unhde worksheets when a set button on a form is clicked | Excel Programming | |||
Issue with workbook not being selected when form button is clicked | Excel Programming | |||
hide or unhide rows with button | Excel Discussion (Misc queries) | |||
Hide/Unhide Form Control | Excel Programming | |||
Hide/Unhide Sheets Form | Excel Programming |