Opening Different Sheets

  • Thread starter Thread starter N1KO
  • Start date Start date
N

N1KO

I've managed to get a cell value to change and i now need to get a command
button to open a sheet which is named exactly the same as that cell value.

So I have Cell J1's value to be 01BudgetJan. I need the command button to
open the sheet called 01BudgetJan. Is this possible?

This value can change so need the button to open whatever sheet has the name
of the cells value.

Thanks in advance.
 
Insert this line in commandbutton code:
Worksheets(Range("J1")).Activate

Regards,
Stefi

„N1KO†ezt írta:
 

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

Moving data to another file - help needed 1
Help to create a macro 2
[values from many sheets] 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
variable sheet name 6
problems getting this macro to work 23
How can I get a macro to opperate from a different sheet 3
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top