Command_Button?
 

OK stupid question but before I head for lunch. I've dropped a
Command_Button on my excel sheet and added the code I need within the
Command_Button sub. Now how do I make the button active when the user loads
the sheet so that they can click on it???

Command_Button?
 

What has made in inactive?

--
HTH

Bob Phillips

"HotRod" wrote in message
...
OK stupid question but before I head for lunch. I've dropped a
Command_Button on my excel sheet and added the code I need within the
Command_Button sub. Now how do I make the button active when the user
loads
the sheet so that they can click on it???

Command_Button?
 

Most probably, you forgot to Exit Design Mode ...
View ToolBars ControlBox
and click on the top first icon on the left ...

HTH

Carim

Command_Button?
 

THANK YOU, I didn't realize that you couldn't keep the design box open.
Makes sense but weird THANKS