Added a command button now I want to use it with code.

[mkingrey]

Hello,

I'm fairly new to using VBA w/ Excel and I just created a routine that runs on a command button click event. I tested the program and it works fine, but now how do I "export" or save the workbook so that I can just open it and use the command button to run the routine. Currently when I open the workbook and click the button it goes to the VBA editor.

Thanks for any help,

Matt

 

[Norie]

Matt

How did you create this button?

I can't see why the VBE is being opened.

When it is opened what do you see?

Are you perhaps still in design mode?

 

[mkingrey]

I fixed the prob, I just didn't close the Design mode in Excel.