Macro runs fine from VBEditor, but not button

P

pickytweety

Oh, guess what. When it worked in the new sheet it made me wonder.....maybe
the other forms control button is interfering. So I deleted the original
button (I hadn't previously deleted the forms control button...I just created
a new CommandButton) and drew the new one and it let me change the caption.
Thanks for your help.
 
D

Dave Peterson

I'm betting that the name of that original button wasn't Commandbutton1. But
it's too late to know for sure <vbg>.

Glad you got it working.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 424, Object required 2
Get the print range from a sheet you just copied for use inthe new 2
Trying to "clean up" some code... 1
2002 vs 2007 MS Office Excel has encountered a problem and needs t 2
Excel 2000 SP3 versus Excel 2007 --error code 0Xc0000005 3
Excel 2003 macro won't run in Excel 2007 5
Excel not showing steps as I F8 through each line of VBA code 1
Any tricks for speeding up this working code? 2

Top