Worksheet Tabs
 

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

--
rhani11
-----------------------------------------------------------------------
rhani111's Profile: http://www.excelforum.com/member.php...fo&userid=1994
View this thread: http://www.excelforum.com/showthread.php?threadid=53219

Worksheet Tabs
 

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