Switch to worksheet view
 

Hello -

I added a command button control to an Excel worksheet, went into the VBA
editor and added the code. My problem is the only way I can run the control
on the worksheet is to Save, Close Excel and re-open Excel, select the
workbook and go to the specific worksheet.
There has to be another way. Would someone explain how to shift views.
Thanks,
Paul

Switch to worksheet view
 

Perhaps you are in designe mode? When you draw a control on a worksheet, you
enter "design mode." Click the button with a triangle and ruler image to
exit design mode.

"Paul Breslin" wrote in message
. ..
Hello -

I added a command button control to an Excel worksheet, went into the VBA
editor and added the code. My problem is the only way I can run the
control
on the worksheet is to Save, Close Excel and re-open Excel, select the
workbook and go to the specific worksheet.
There has to be another way. Would someone explain how to shift views.
Thanks,
Paul

Switch to worksheet view
 

Yes, thank you - that worked like a charm.
Paul



"Bob Kilmer" wrote in message
...
Perhaps you are in designe mode? When you draw a control on a worksheet,
you
enter "design mode." Click the button with a triangle and ruler image to
exit design mode.

"Paul Breslin" wrote in message
. ..
Hello -

I added a command button control to an Excel worksheet, went into the VBA
editor and added the code. My problem is the only way I can run the
control
on the worksheet is to Save, Close Excel and re-open Excel, select the
workbook and go to the specific worksheet.
There has to be another way. Would someone explain how to shift views.
Thanks,
Paul