Excel 2000 Worksheet show problem

[Greg Simms]

Hello, the code below reveals a worksheet. However all it does is to make
the worksheet visible.

What do I add to the code to make the Tie Bar Worksheet the active worksheet
on screen

Private Sub cmdtie_Click()
Worksheets("Tie Bars").Visible = True
End

Thanking you all in advance

Greg Simms

 

[Frank Kabel]

Hi
try
Private Sub cmdtie_Click()
Worksheets("Tie Bars").Visible = True
Worksheets("Tie Bars").activate
End

 

[Greg Simms]

Thank You very much, it works a treat

Greg Simms