Start of an open discussion on Camera, etc.

wi_guy · Apr 2nd, 2002, 02:49 PM

I think many people don't know about custom toolbars, to make their life easier.......to have toolbar buttons for many of thier common tasks. IF you don't know how to create one, its: View:toolbars:Customize, then click NEW and ok, then drag the created box to your menu bar:, then you can add handy features: go to the commands tab and choose functions that you want, and drag the icon into the box you just created. That said and done, the real question I'm posing is: for those of you who use this, What buttons do you use the most in your applications?

Chris Davison · Apr 2nd, 2002, 03:12 PM

Occupation : Accountant

Icons : ( + - / * ) & , % E (sum) Fx PSV Autofilter left/mid/right alignments Properties <-0.00 0.00-> macro B i U borders palette camera ^A vA undo redo

[ This Message was edited by: Chris Davison on 2002-04-02 14:14 ]

Mark W. · Apr 2nd, 2002, 03:28 PM

You don't need both...

1. Save/Open
2. Sort Ascending/Sort Descending
3. Print/Page Preview
4. Increase Decimal/Decrease Decimal
5. Center/Merge and Center
6. Align Left/Align Right

...because holding the Shift key while clicking toggles between these paired (related) commands.

[ This Message was edited by: Mark W. on 2002-04-02 15:00 ]

wi_guy · Apr 2nd, 2002, 07:11 PM

Thanks Mark, I didn't know that shift key trick

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 02:49 PM	#1
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	I think many people don't know about custom toolbars, to make their life easier.......to have toolbar buttons for many of thier common tasks. IF you don't know how to create one, its: View:toolbars:Customize, then click NEW and ok, then drag the created box to your menu bar:, then you can add handy features: go to the commands tab and choose functions that you want, and drag the icon into the box you just created. That said and done, the real question I'm posing is: for those of you who use this, What buttons do you use the most in your applications?

Apr 2nd, 2002, 03:12 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Occupation : Accountant Icons : ( + - / * ) & , % E (sum) Fx PSV Autofilter left/mid/right alignments Properties <-0.00 0.00-> macro B i U borders palette camera ^A vA undo redo [ This Message was edited by: Chris Davison on 2002-04-02 14:14 ]

Apr 2nd, 2002, 03:28 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You don't need both... 1. Save/Open 2. Sort Ascending/Sort Descending 3. Print/Page Preview 4. Increase Decimal/Decrease Decimal 5. Center/Merge and Center 6. Align Left/Align Right ...because holding the Shift key while clicking toggles between these paired (related) commands. [ This Message was edited by: Mark W. on 2002-04-02 15:00 ]

Apr 2nd, 2002, 07:11 PM	#4
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	Thanks Mark, I didn't know that shift key trick