Control Button
 

I have more than 100 worksheet in a workbook among which I have to continuous
use 4-5 worksheet. Can I add buttons with the names of these worksheet in a
worksheet. So that by just clicking in a particular sheet name button I can
directly reach into that sheet.

Jai

Control Button
 

You can rightclick on the VCR like (DVD like???) controls to the left of the
worksheet tabs and see a list (or choose More Sheets) and select a worksheet
from there.

Or you could try an addin from Debra Dalgleish's site:
http://contextures.com/xlToolbar01.html

jai wrote:

I have more than 100 worksheet in a workbook among which I have to continuous
use 4-5 worksheet. Can I add buttons with the names of these worksheet in a
worksheet. So that by just clicking in a particular sheet name button I can
directly reach into that sheet.

Jai

--

Dave Peterson

Control Button
 

Hi,

Do the following;

1. On the Insert menu, point to Name, and then select Define.
The Define name dialog appears.

Note: If you wish to define name for emplty cell, you can assign a name.

2. Enter a name in the "Names in workbook" text box.
3. Verify the reference to the cell location, in the Refers to text box.
Note: you can modfy the cell reference to a different location in this
Refers to text box.
4. Click the Add button.
5. Verify that the name you defined for the cell is listed in the Names in
Workbook list. Click OK to return to the worksheet.
6. Repeat Step 1 to Step 5 for other worksheet you frequent use.
7. To display the Go To dialog box, do one of the following:
Press F5 key
-or-
On the Edit menu, click Go To
8. From the Go to list, select a named definition you defined and then click
OK

Challa Prabhu

"jai" wrote:

I have more than 100 worksheet in a workbook among which I have to continuous
use 4-5 worksheet. Can I add buttons with the names of these worksheet in a
worksheet. So that by just clicking in a particular sheet name button I can
directly reach into that sheet.

Jai