worksheets

G

Guest

can i asign a command to a button that woulld switch to another worksheet
within a workbook?
 
N

N10

Josh said:
can i asign a command to a button that woulld switch to another worksheet
within a workbook?
Click to expand...

Yes try for example

Sheets("Sheet1").Select

or use the macro recrorder

Best N10:)
 
B

Bob Phillips

Can't you just use Ctrl-PageUp/PageDown?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Move/Copy Worksheet with Macros 2
command buttons disappear when I move worksheet 2007 1
Column Nmaes and Row Names 2
Formula for Serial Date n+2 +2 +3 +2 +2 +3... 4
Chart Colour 2
CommandButton to open a Excel workbook 2

Top