Excel 2000 Worksheet show problem

  • Thread starter Thread starter Greg Simms
  • Start date Start date
G

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
 
Hi
try
Private Sub cmdtie_Click()
Worksheets("Tie Bars").Visible = True
Worksheets("Tie Bars").activate
End
 
Back
Top