selecting workbook/sheet

[msnarayanan]

dear all

i have created a workbook with 7 or 8 sheets.
while some sheets are protected, the other sheets are for data entry.
the protected sheets are for viewing/printing only. the fields are picked up from the data tables.

i wonder is it possible to select and open the specied sheets by a click of the button - say
menu driven table.

the table may look as below:

1. Data entry for Sales - if this is clicked it should open the
corresponding sheet in the workbook
2. Data entry for Purchases - as above
3. View Print Consolidated Sales
etc.

i can select the sheets by clicking the respective files, appearing at the bottom. but for
presenting the options, in a better looking menu.

your help and advice is sought.

m s narayanan

 

[Becky]

You can insert hyperlinks into your workbook, and I think that would do what you are looking to achieve.

Type the link text, then with the cell highlighted go to the Insert tab, and click on Hyperlink. Within the options menu select 'Place in this document' - you can then specify which sheet and which cell. Finish by pressing OK to create the link.

 

[msnarayanan]

dear becky
thanks for your help. the suggestion made by you did work.
one more help - the hyperlink shows all the sheets in the workbook.
as data for each sheet is entered by different staff, i wonder whether
i can createa hyperlink only to show a specific sheet - instead of
all sheets in the workbook.

m s narayanan

 

[Becky]

I'm afraid I don't know of a way to do that