Need to always go to Sheet1

  • Thread starter Thread starter keith
  • Start date Start date
K

keith

Hi
I am using a RefEdit bx as shown below.
When the box is clicked to start, I want to always show Sheet1 for the
selections.
The following code did not work. I got this code by using the macro
recorder, so must have missed something else that's needed.

What would work here?


Private Sub RefEdit1_DropButtonClick()

Sheets("Sheet1").Select
Sheets("Sheet1").Show

End Sub

Thank you,
Keith
 
Hi Simon,
thanks very much.
keith

Simon Lloyd said:
Hi, using this
Private Sub RefEdit1_DropButtonClick()
Sheets("Sheet1").Activate
End Sub

will ensure that the first sheet the user gets to click will be sheet
1.




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
Click to expand...
 
Back
Top