Hi, I have a button assciated with a macro, but I want to make sure that
the button isn't pressed by mistake.
So I was thinking of having a checkbox, that when checked enables the
command button, and when unchecked the button is disabled.
How do I do that?


--
Ruatha
------------------------------------------------------------------------
Ruatha's Profile: http://www.excelforum.com/member.php...o&userid=31083
View this thread: http://www.excelforum.com/showthread...hreadid=550770

I think I'd just add a bit to the macro that is associated with the button.

Option explicit
sub yoursubhere()

dim resp as long

resp = msgbox(Prompt:="Are you sure you want to do all this stuff", _
buttons:=vbyesno)

if resp = vbno then
exit sub
end if

'rest of your code here

Ruatha wrote:

Hi, I have a button assciated with a macro, but I want to make sure that
the button isn't pressed by mistake.
So I was thinking of having a checkbox, that when checked enables the
command button, and when unchecked the button is disabled.
How do I do that?

--
Ruatha
------------------------------------------------------------------------
Ruatha's Profile: http://www.excelforum.com/member.php...o&userid=31083
View this thread: http://www.excelforum.com/showthread...hreadid=550770

--

Dave Peterson

Thanx for the help, I'll do that!


--
Ruatha
------------------------------------------------------------------------
Ruatha's Profile: http://www.excelforum.com/member.php...o&userid=31083
View this thread: http://www.excelforum.com/showthread...hreadid=550770