Worksheet Tabs

[rhani111]

Howdy All,

Thanks for any assistance before I begin...lol

What I have is about 25 worksheets in a single workbook. Each workshee
has several macro buttons on them. What I want to be able to do, is giv
the user the option to use the macro button OR the sheet tabs t
navigate around the workbook. At the moment, if the user clicks th
Sheet tab at the bottom of the worksheet and opens another sheet, th
macro button that is on the second sheet displays a black bar acros
it.

Is there something I can do to get the worksheet to default to
certain cell when the worksheet tab is used instead of the macr
button?

Tar muchly
Rhan

 

[Guest]

Either use an on activation command in the sheet code
Or use a drawing object or hyperlink to navigate around the worbook.