Disable Button

  • Thread starter Thread starter Pete JM
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Macro Work On A Different PC 5
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Run two macros for two different sheets 11
VBA set thick borders around non empty cells in range 0
Simple Macro 1
Run code based on cell contents 2
disable macros in a worksheet 5
VBA Pivot Table Error 1

Back
Top