View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave ferris Dave ferris is offline
external usenet poster
 
Posts: 7
Default hide and unhde worksheets when a set button on a form is clicked

hi everyone,
i have a work book with 4 worksheets i have a userform that is initialised
when the workbook is opened. on the form is 4 buttons one for each sheet.
button one would show the worksheet tabs for sheets 1 and 2,
button two would show the worksheet tabs for sheets 1 and 3,
button three would show the worksheet tabs for sheet 1,
button four would show the worksheet tabs for sheets 1 and 4,

i'm taking it that by hiding the worksheet tabs that the worksheet itself is
hidden!

help in this dilema is very much appreciated.
thank you

Dave ferris