ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Switch between different work sheets Randomly (https://www.excelbanter.com/excel-discussion-misc-queries/111412-how-switch-between-different-work-sheets-randomly.html)

Thejesh.Giri

How to Switch between different work sheets Randomly
 
If i want to Open Specific Work Sheet without using CTRL+Page Down or
CTRL+Page Up, how to do that? since if i use CTRL+Page Down or CTRL+Page Up i
should move in Sequential Order, i want to know how to Open work sheet in
Random Order

Don Guillett

How to Switch between different work sheets Randomly
 
why?

--
Don Guillett
SalesAid Software

"Thejesh.Giri" wrote in message
...
If i want to Open Specific Work Sheet without using CTRL+Page Down or
CTRL+Page Up, how to do that? since if i use CTRL+Page Down or CTRL+Page
Up i
should move in Sequential Order, i want to know how to Open work sheet in
Random Order




Gord Dibben

How to Switch between different work sheets Randomly
 
Right-click on one of the navigation arrows at bottom left to get a list of 15
sheets and "more sheets"

OR use a VBA approach to select from a list of sheets with the click of the
mouse.


Gord Dibben MS Excel MVP

On Mon, 25 Sep 2006 07:32:02 -0700, Thejesh.Giri
wrote:

If i want to Open Specific Work Sheet without using CTRL+Page Down or
CTRL+Page Up, how to do that? since if i use CTRL+Page Down or CTRL+Page Up i
should move in Sequential Order, i want to know how to Open work sheet in
Random Order




All times are GMT +1. The time now is 12:36 AM.

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