How to make a spreadsheet as popup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
use a code like
.....
activeworkbook.worksheets("sheet2").activate
....
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to Same sheet but after that want to hide link sheet 1
How to run a macro automatically when i open my excel spreadsheet 2
Range(sheet2) = Range(sheet1) 11
How to keep the Checkboxes selected by the user unchanged even after closing the userform 5
How to check output folder has been created in the network path?using VBA programming 5
How to activate Sheet2? 5
How to get a range of values into a combo placed on USERFORM? 3
Form based on rows 5

Back
Top