Command Button

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

What is the VB to open a sheet when a command button is clicked.

I know this is very basic stuff for a lot of you and I do very much
appreciate the help.
 
Do you mean to select a sheet, or open a new workbook?

Try something like

Private Sub CommandButton1_Click()
Worksheets("mySheet").Activate
End Sub

or

Private Sub CommandButton1_Click()
Workbooks("C:\mybook.xls").Open
End Sub


HTH,
JP
 
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

Command Buttons & ActiveX Controls 2
Access Automatically Send a notification email once a record is added 0
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Code for Command Buttons 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
losing command button functionality 4
Command Button Excel 2007 4
'Cannot insert object' message when I try to put a button on a worksheet 7

Back
Top