command button on form to open sheets

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

Guest

Can I simply use a hyperlink to open a sheet from a command button on a form?
I don't see how to do this? Is there any code out there to do this?
 
Talking about a UserForm in VBA or a form that you just created in a
worksheet? By Sheet do you mean a worksheet within the current
workbook, or do you meen a separate workbook?
If a UserFrom:
Sheets("ThisSheet").Activate will activate the sheet called
"ThisSheet"
Workbooks.Open "C:\ThisWorkbook.xls" will open the workbook in the C:\
dirve called "ThisWorkbook".

If you are referring to a form on a worksheet, then the same code can
be applied. Just right click on the command button in your shet and
select Assign Macro.
 
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 not responding 7
Hyperlink to Same sheet but after that want to hide link sheet 1
exit form and close sheet 3
Command Buttons not responding 3
How to use multiple command button to copy user form data to multiple worksheet 0
button names changed on copied sheet 4
Button to take the user in a different place on the same sheet 4
Command Button Question 8

Back
Top