Pete,

At the beginning of the procedure, use code like

If Range("A1").Value = False Then
Exit Sub
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Pete JM " wrote in
message ...
hi,

Is there a peice of code i could add to the beginning of a
macro that
would look in a cell, say A1 and if the value in that cell is
False the
macro would not run. But if the Value is True then let the
macro run.

Regards

Pete


---
Message posted from http://www.ExcelForum.com/