View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Jackson Jim Jackson is offline
external usenet poster
 
Posts: 324
Default How do I initiate a macro directly in a worksheet?

All you need is a Command Button. Click on "View/Toolbars/Control Toolbox.
You will see, among others, the Command Button icon. Click it and click on
the sheet where you want the button. When you double-click the button a
Macro will be set up for you to place your code in. If you right-click the
button and choose "Properties" you can change the Caption on it etc.

--
Best wishes,

Jim


"AMMPro" wrote:

I would like to click on a cell and initiate a macro. Is it possible?