ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/129353-worksheets.html)

Josh

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

N10

worksheets
 

"Josh" wrote in message
...
can i asign a command to a button that woulld switch to another worksheet
within a workbook?


Yes try for example

Sheets("Sheet1").Select

or use the macro recrorder

Best N10:)



Bob Phillips

worksheets
 
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)



"Josh" wrote in message
...
can i asign a command to a button that woulld switch to another worksheet
within a workbook?





All times are GMT +1. The time now is 07:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com