can i asign a command to a button that woulld switch to another worksheet within a workbook?
J Josh Feb 6, 2007 #1 can i asign a command to a button that woulld switch to another worksheet within a workbook?
N N10 Feb 6, 2007 #2 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
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 Feb 6, 2007 #3 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)
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)
