Hi Gtton,

Try changing:

Sheets.CommandButton1.enabled = false 'Gray out the button

to

Me.CommandButton1.Enabled = False 'Gray out the button

---
Regards,
Norman



"gtton" wrote in
message ...

Hi Jim, I tried the command button and it won't execute the macro. It
takes me to the Visual Basic Editor


--
gtton
------------------------------------------------------------------------
gtton's Profile:
http://www.excelforum.com/member.php...o&userid=24721
View this thread: http://www.excelforum.com/showthread...hreadid=383303