Solved: Hide then unhide worksheet

[Johnpants]

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]

To hide a worksheet:[VBA]ThisWorkbook.Sheets("Data").Visible = False[/VBA](and =True to show it again)
To got to a visible sheet:
[VBA]ThisWorkbook.Sheets("Data").Activate[/VBA]

[Johnpants]

Excellent, thank you very much it does just what I wanted.