Leith,

I tried both versions, and got two diffrent error messages with each.
I.E. neither worked. I had already changed the name back to
CommandButton1, but but I went back and double check just in case.
Still no dice. I will try Tom's suggestion and let you both know how it
goes.

Thanks,
Amber

Leith Ross Wrote:
Hello Amber_D_Laws,

If you created the command button from the Excel menu then it is a
Forms type. If you created it using the VBA Toolbar then it is a
Control Toolbox type. If you still aren't sure, try each code version.

You are correct about the name needing to be changed to CommandButton1.
When you change the name of the control, it only effects the project
references, not the system reference.

Sincerely,
Leith Ross


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=507754