I recorded a macro that copys one cell and pastes it to another cell o
another sheet. Then I assigned it to a check box. It works just fine
but what I would like is:
How do I stop the macro from running if I uncheck the box

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

Please post the code you used. - Piku

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

Sub flip1()
'
' flip1 Macro
' Macro recorded 4/13/2004 by
'

'
Sheets("Comments").Select
Range("B2:M3").Select
End Sub

This code is for check box 10.
I'm new to all of this so please bare with me

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

Well, that's the Subroutine that's being called, but where is it bein
called from? If it's in the checkbox itself you could alter that lik
this:

If CheckBox10.Value = True Then
flip1()
End If

To do what you want you need to use the IF statement, but where to pu
it exactly is the only question. - Piku

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