View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Getting control toolbox button to record a macro.

Click VIEW in the menu and select TOOLBARS and display the Control Toolbox
toolbar. Right click on the Control Toolbox toolbar and select CUSTOMIZE.
Click t the commands tab and in the CATEGORIES listbox, click TOOLS. In the
COMMANDS list box scroll down until the RECORD NEW MACRO command button
appears and then drag the button to the Control Toolbox toolbar.

That button is not assigned to that toolbar and it sounds as if it has been
reset to the default set of command buttons.
--
Kevin Backmann


"suek" wrote:

Hello,

Don't know what I've done, but I used to be able to select the button in the
control toolbox, and it would automatically launch into creating a macro. It
is not doing it any more, and I can't find out how to change it back. Any
suggestions? Currently creating modules and then cutting and pasting to the
command button, which is a bit frustrating.

Thanks!