Run code on button press or tab select

[ipbr21054]

Hi,
I have several worksheets within my workbook.
On one worksheet when i visit it i have columns Y:AH within my view upon open.
On another worksheet i have a button which goes to the worksheet above but column AV

As you can see this is the clash.

Can the code be controlled/run depending if you click a button or select the tab of the sheet ?

Thanks

 

[ipbr21054]

I thought this might sort my issue out,

I have a macro of which when i click on run it runs fine so that code is working.
However in a module i put the following but it doesn't call the macro mentioned above,did i write it incorrectly ?

Private Sub Worksheet_Activate()Call InfoCells Macro
End Sub

 

[Fluff]

What is the name of the macro you want to call. Please supply the full title ie

Private Sub Macro1()

 

[ipbr21054]

The macro is called InfoCells

 

[My Aswer Is This]

Try this:

Private Sub Worksheet_Activate()
Call Infocells
End Sub

 

[ipbr21054]

Thanks but isn’t that what I showed in post 2

 

[Fluff]

Nope, you had the word Macro afterwards, MAIT doesn't.

 

[ipbr21054]

Sorry I now see the difference.

 

[ipbr21054]

Many thanks for the advice.
The above didnt work so ive decided to have both items on the same sheet.

Thanks