Disable a macro

[loubeelou]

Is there a way i can disable a macro if a cell isn't filled in? So that the button just won't press if there's no information in a specific cell?

 

[lenze]

Hi and welcome to the board!!
Why not just Exit the Macro if that cell is null

If Range("$A$1") = "" Then 
   MsgBox "You must enter data in $A$1!!!"
   Range("$A$1").Select
   Exit Sub
End If

lenze

 

[loubeelou]

okay that sounds great, thankyou! i'm really not familiar with visual basic, so i just have no idea!

 

[Domski]

You could just pop something like this at the start of the sub:

If Sheets("Sheet1").Range("A1") = "" Then Exit Sub

Dom

 

[loubeelou]

you seem quite familiar with Visual basic, is it similar to other programming languages? i'm doing pascal in my computing lessons, and bits look familiar, does it work in the same sort of way?

 

[emily2309]

I have tried using this code for my spreadsheet, which is similar to my friends above. However, when i then use the macro, it then comes up with "Compile Error, Invalid Outside Procedure". HELP???

 

[lenze]

Hi Emily: Can you post your code so we can see what may be causing this error? What do you need to do?
lenze