Disable Button
 

hi,

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

Regards

Pet

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

Disable Button
 

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/

Disable Button
 

Perfect!

Thank you very much for you help

Regards

Pet

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