Wanting to Create A Command Button Command

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

Guest

I am wanting to create a command button that once it is clicked on it will
change the active worksheet to the next worksheet in the workbook. For
example, if I am on worksheet1 and click the button it will select worksheet2
and so on. I would like to create it so I do not have to have seperate
command buttons for each page if at all possible.

Thanks

Bumper
 
hi bumper338

ActiveSheet.Next.Select

Why not use the shortcuts Ctrl PgUP and Ctrl Pg Down
 
Thanks that is what I was looking for.

I don't want to use shortcuts because it will only confuse my end users.

Thanks again,

Bumper
 
Be sure that you test if the last sheet is selected before you run the code line
 

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 Button Question 8
Command button does not run code 2
Command button naming issue 1
How to use multiple command button to copy user form data to multiple worksheet 0
trigger worksheet activate event in another worksheet 2
How do Excel define the application area? 3
Copy a command button 1
Hide a command button 9

Back
Top