How to make a spreadsheet as popup?
 

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

How to make a spreadsheet as popup?
 

Hi
use a code like
.....
activeworkbook.worksheets("sheet2").activate
....

--
Regards
Frank Kabel
Frankfurt, Germany


Harinath wrote:
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

How to make a spreadsheet as popup?
 

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

"Harinath" wrote in message
...
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