PDA

View Full Version : Solved: Hide then unhide worksheet



Johnpants
11-11-2005, 02:42 AM
Hi, I have a workbook with 2 worksheets called 'Data' and 'Calendar'. There is a userform on calendar that users use to enter data. What I am trying to do is that when they come to enter the data, it places it all in the workbook, then hides 'Data' and goes straight to 'Calendar'. The next thing I would like to do is when they come to use the commandbtton that updates the information on calendar to data it unhides and goes to that worksheet...

How easy is this?

Thanks,

John.

Killian
11-11-2005, 02:57 AM
To hide a worksheet:ThisWorkbook.Sheets("Data").Visible = False(and =True to show it again)
To got to a visible sheet:
ThisWorkbook.Sheets("Data").Activate

Johnpants
11-11-2005, 03:07 AM
Excellent, thank you very much it does just what I wanted. :)