Run MACRO from the valve of a cell?
 

Does anyone know if I can run a MACRO from the value of a cell?

If cell "A1" is greater the 42 I would like to either close the worksheet
with out saving or protect if from any more changes.

--
Francis X. Boudreaux

Run MACRO from the valve of a cell?
 

Hi
you'll need an event procedure for this. See:
http://www.cpearson.com/excel/events.htm

--
Regards
Frank Kabel
Frankfurt, Germany


FX Boudreaux wrote:
Does anyone know if I can run a MACRO from the value of a cell?

If cell "A1" is greater the 42 I would like to either close the
worksheet with out saving or protect if from any more changes.

Run MACRO from the valve of a cell?
 

You will need an onsheet event.
Right click the sheet tab, view code.
Put this macro into the sheet module

Sub Doobee()
set a=range("A1")
if a.value 42 then
activeworkbook.close false
'changes not saved

end if

end sub

Regards
Mark


-----Original Message-----
Does anyone know if I can run a MACRO from the value of a
cell?

If cell "A1" is greater the 42 I would like to either
close the worksheet
with out saving or protect if from any more changes.

--
Francis X. Boudreaux