How to make a spreadsheet as popup?

H

Harinath

Hi all,

I have typical problem here,i want to create a button on sheet1 and link this button to sheet2.
when i click on the button in sheet 1 it should open sheet 2 how to do this?
Is this possible to do?
Please put some light on this.

Thanks
Harinath
 
N

Nigel

Add the button to sheet1, in design mode click the button and add the code
into the button click event as follows.....

Private Sub CommandButton1_Click()
Sheets("Sheet2").Activate
End Sub

Cheers
Nigel
 
Top