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


"rhani111" wrote:


Howdy All,

Thanks for any assistance before I begin...lol

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

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

Tar muchly
Rhani


--
rhani111
------------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...o&userid=19940
View this thread: http://www.excelforum.com/showthread...hreadid=532196