How to run a macro based on a cell value

[mrbret]

Morning clever people

I need a little help again. I want to be able to run the Macro below based on cell "I9" so when I9 = not blank then the macro runs. Is that doable with massive amount of coding?

Thanks for any help

This is the current Macro that runs when the Macro button is pressed:

Sub SaveAs()
'
' SaveAs Macro
' Save As
'

'
Sheets("CB Checklist").Select
ActiveSheet.Unprotect
Range("M6:N6").Select
Selection.Copy
Range("M8:N8").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Sheets("CB Checklist").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Range("M8:N8").Select
End Sub

[IonutC]

HI,

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Please review the forum rules about posting code. Refer too Rule No. 3. Use code tags when posting too the forum.

http://www.excelforum.com/forum-rule...rum-rules.html

Try:

Please Login or Register  to view this content.

[mrbret]

HI,

Please Login or Register  to view this content.

Wow, that simple? Thanks very much

Please review the forum rules about posting code. Refer too Rule No. 3. Use code tags when posting too the forum.

http://www.excelforum.com/forum-rule...rum-rules.html

Try:

Please Login or Register  to view this content.

Sorry, my mistake, I'd only added it as a visual aide not as a copy/paste. I'll be sure to do the CODE bit next time. Thanks

[JOHN H. DAVIS]

You're welcome. Thanks for the reps. Glad help out, if you are satisfied with the solutions provided then mark this thread as SOLVED. Again refer to the link in Post #3.