Disable Button

P

Pete JM

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
 
C

Chip Pearson

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
 
Top