| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using a popup to make percenatges on selected cells | Excel Discussion (Misc queries) | |||
| How to make excel popup windows | Excel Discussion (Misc queries) | |||
| I cant make entries in my spreadsheet | Excel Discussion (Misc queries) | |||
| make a spreadsheet | Excel Discussion (Misc queries) | |||
| how do I make a spreadsheet fit the right margin. | Excel Worksheet Functions | |||
Hybrid Mode
