Customize tool bar in 2007

[mark hansen]

Is there a way to drag a Auto shape button (tool) on a tool bar in Excel 2007?

This would be similar to the 2003 process of (Tool --> customize --> Command Tab - Auto Shape.) then find the shape you use a lot, in my case Scribble tool, and drag it out to a tool bar for quick and easy access.

Can you customize tool bars in 2007?

Along the same lines, can you surface a drawing tool bar along the bottom of the screen.

Thanks for any help... Still trying to make the conversion to office 2007.

 

[RoryA]

You can add it to the Quick Access Toolbar (above the Ribbon) easily enough - right-click it, Customize QAT, change the dropdown to show all commands then locate Scribble in the list.
You can't have a toolbar at the bottom of the screen as far as I know, and the only way to customise the ribbon is to use XML (unless you just want commands added to the add-ins tab)

 

[mark hansen]

Thanks for the information and quick response!!! I didn't know the Save, undo etc buttons were in a customizable area. That opens up lots of other possibilities to get over the 2007 hump.

Thanks
Mark