ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   add button to standard menu bar (https://www.excelbanter.com/excel-programming/351700-add-button-standard-menu-bar.html)

[email protected]

add button to standard menu bar
 
I remember reading a post on how to add a standard button (say... the
Bold button) to the menu next to the Help menu. But I've looked
around and I can't find that post anymore. I don't need to do it
programatically, just manually. Thanks.

(The reason I want to do this is that there is no keyboard shortcut to
-- for example -- increase a cell's indent, but there is a button on
the format toolbar. So by adding that button to the menu at least I
could press Alt - H - [right arrow] - enter, which would be faster than
going to the mouse. I know I could create a macro with shortcut
button, but the workbooks I'm working with don't have macros and I want
to keep it that way.)


Norman Jones

add button to standard menu bar
 
Hi Bodhi,

Try:

View | Toolbars | Customize | Commands | Select 'Format' category

Now, scroll through the available commands (including increase and decrease
indents) and drag the desired command(s) to a toolbar.

Finally, close the dialog.

---
Regards,
Norman



wrote in message
oups.com...
I remember reading a post on how to add a standard button (say... the
Bold button) to the menu next to the Help menu. But I've looked
around and I can't find that post anymore. I don't need to do it
programatically, just manually. Thanks.

(The reason I want to do this is that there is no keyboard shortcut to
-- for example -- increase a cell's indent, but there is a button on
the format toolbar. So by adding that button to the menu at least I
could press Alt - H - [right arrow] - enter, which would be faster than
going to the mouse. I know I could create a macro with shortcut
button, but the workbooks I'm working with don't have macros and I want
to keep it that way.)




Dave Peterson

add button to standard menu bar
 
Tools|Customize (just to see that dialog).

Now you can be quick and dangerous or you can be slow and safe...

Quick and dangerous.
Ctrl-click and drag the existing Bold icon to the other location. If you forget
to use ctrl-click and drag, you'll be moving the icon to a different location.

Slow(er) and safe(er)
Commands Tab|Format category
look for the Bold icon and drag it from the dialog to your favorite toolbar (as
many times as you want!).



wrote:

I remember reading a post on how to add a standard button (say... the
Bold button) to the menu next to the Help menu. But I've looked
around and I can't find that post anymore. I don't need to do it
programatically, just manually. Thanks.

(The reason I want to do this is that there is no keyboard shortcut to
-- for example -- increase a cell's indent, but there is a button on
the format toolbar. So by adding that button to the menu at least I
could press Alt - H - [right arrow] - enter, which would be faster than
going to the mouse. I know I could create a macro with shortcut
button, but the workbooks I'm working with don't have macros and I want
to keep it that way.)


--

Dave Peterson


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com