Macro runs fine from VBEditor, but not button

  • Thread starter Thread starter pickytweety
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

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
Excel 2003 macro won't run in Excel 2007 5
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 not showing steps as I F8 through each line of VBA code 1
Looping within a loop 1

Back
Top