ActiveCell or ActiveSheet
 

I have a Workbook with 10 sheets. Each has approximately 8 or 10 Macros +
Links. When the Workbook is opened, cell A1 is selected. Each of the macros
listed on the left side opens an existing tab or worksheet, which is part of
the Workbook. Each time a new sheet is opened, cell A1 is selected.

Once in awhile (too frequently) when one of the macros or external links is
clicked on any of the pages, nothing happens. Sometimes, the second click
activates the Macro, and sometimes a blank cell has to be selected 1st and
then the macros will work.

I think I need a line of code either at the beginning or end of each Macro
that will somehow make the macro recoginize that the sheet displayed is the
activesheet, so that the click on the macro always works.

Any ideas everyone ?

Matt@Launchnet

--
Please take a look at www.openoursite.com Click on: "Keywords" and then
Click on "Matt's Story" and if you are a man, you should be very happy that
you read my story. God Bless for everyones help.

Message posted via http://www.officekb.com

ActiveCell or ActiveSheet
 

I think I found a solution last night. I was using code:

Range("a1").Select

Last night I changed it to:

Application.Goto Reference:="R1C1"

Seems OK, but I want to test some more.

Thanks
Matt@Launchnet

Launchnet wrote:
I have a Workbook with 10 sheets. Each has approximately 8 or 10 Macros +
Links. When the Workbook is opened, cell A1 is selected. Each of the macros
listed on the left side opens an existing tab or worksheet, which is part of
the Workbook. Each time a new sheet is opened, cell A1 is selected.

Once in awhile (too frequently) when one of the macros or external links is
clicked on any of the pages, nothing happens. Sometimes, the second click
activates the Macro, and sometimes a blank cell has to be selected 1st and
then the macros will work.

I think I need a line of code either at the beginning or end of each Macro
that will somehow make the macro recoginize that the sheet displayed is the
activesheet, so that the click on the macro always works.

Any ideas everyone ?

Matt@Launchnet


--
Please take a look at www.openoursite.com Click on: "Keywords" and then
Click on "Matt's Story" and if you are a man, you should be very happy that
you read my story. God Bless for everyones help.

Message posted via http://www.officekb.com