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

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

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