calling a macro upon selecting a cell
 

when i select a cell, say B2, a message box comes up with a message i wrote
in a macro at some point in the past. it asks if i want to proceed w/ the
subroutine. for the life of me, i cannot figure out how to get to this code.
it does not appear to be in vbe, at least not under modules (there are non
in this spreadsheet). how do you call a sub by simply selecting a cell and
where is the code stored? thanks, mike allen
--
mikeallen

calling a macro upon selecting a cell
 

Right click on the sheet tab of the sheet the cell is in. Then click View
Code.
It sounds like a worksheet_change macro.

"mikeallen77" wrote:

when i select a cell, say B2, a message box comes up with a message i wrote
in a macro at some point in the past. it asks if i want to proceed w/ the
subroutine. for the life of me, i cannot figure out how to get to this code.
it does not appear to be in vbe, at least not under modules (there are non
in this spreadsheet). how do you call a sub by simply selecting a cell and
where is the code stored? thanks, mike allen
--
mikeallen

calling a macro upon selecting a cell
 

perfect! i would have never found it, even though i have obviously used it
before. thank you.
--
mikeallen


"JLGWhiz" wrote:

Right click on the sheet tab of the sheet the cell is in. Then click View
Code.
It sounds like a worksheet_change macro.

"mikeallen77" wrote:

when i select a cell, say B2, a message box comes up with a message i wrote
in a macro at some point in the past. it asks if i want to proceed w/ the
subroutine. for the life of me, i cannot figure out how to get to this code.
it does not appear to be in vbe, at least not under modules (there are non
in this spreadsheet). how do you call a sub by simply selecting a cell and
where is the code stored? thanks, mike allen
--
mikeallen