custom toolbar

[novice1]

Is it possible to change the new workbook icon action to do something else (i.e. to my own macro)? So instead of opening a new workbook when I click the "New" icon it runs my macro.

 

[Mark F]

If you really want to do this(not sure I would!),
Rightclick the icon
Customise
Then Righclick again
Assign Macro
Close


Another option might be to add your new button to the toolbar and copy the button image of the exixting one (and perhaps edit it slightly to make it obvious it is different?)
First put YOUR button on the toolbar with whatever the button image is at the moment

Tools
Customise
Macros
"Drag the Yellow Smiley to the toolbar"
"Right Click the Yellow Smiley and Assign your Macro
Don't press "Close" yet
Right click the "new workbook" icon and "Copy Button Iimage"
Right click your yellow smiley and "Paste Button Image"
Right click your now not yellow smiley and "Edit Button Image"
Close

Of course, this may not be what you want at all!

Mark

 

[novice1]

Is it possible to create a custom toolbar that does not display the custom icon on other workbooks?

 

[al_b_cnu]

Hi,

check out the title 'Creating custom Menus' in the following link http://spreadsheetpage.com/index.php/tip/C30