Group:  Microsoft Excel ยป microsoft.public.excel.misc
Thread: How to Switch between different work sheets Randomly

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

How to Switch between different work sheets Randomly
Thejesh.Giri 25.09.2006 14:32:02
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
Re: How to Switch between different work sheets Randomly
"Don Guillett" <dguillett1[ at ]austin.rr.com> 25.09.2006 14:37:26
why?

--
Don Guillett
SalesAid Software
dguillett1[ at ]austin.rr.com
"Thejesh.Giri" <Thejesh.Giri[ at ]discussions.microsoft.com> wrote in message
news:720D3B20-2DED-4C6A-974F-A62342EE54CC[ at ]microsoft.com...
[Quoted Text]
> 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


Re: How to Switch between different work sheets Randomly
Gord Dibben <gorddibbATshawDOTca> 25.09.2006 20:12:17
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
<Thejesh.Giri[ at ]discussions.microsoft.com> wrote:

[Quoted Text]
>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

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net