Adding macro in to toolbar as tool bar button, creating macro and adding it, with small example

How nice it would be if your favourite macro is available as toolbar button. Its really easy to do. Suppose you have created a macro hello and you want to add it, then just follow these step:

Adding macro to toolbar

1. Go to menu: tools->Customize… => it will open Customize window.
2. In Customize window go to ‘Commands’ tab and select ‘Macros’ at left pane, all the macros you have created would be visible at right pane.
3. Just drag the macro you want to toolbar.
4. It would automatically create a button with macro name.

Customizing toolbar macro button

1. Write click on macro toolbar button while Customize window is open.
2. In this menu you can do all the customization. Changing name, image etc.
3. You can also assign a shortcut key. Just put &1(if you want alt+1 to a shortcut key) or which ever combination you want.

Office tips and tricks: Creating and adding new toolbar in ms office, a very simple example

You would have seen many toolbars in your office app. Have you ever thought of having toolbar with your own name . Yes you can add new tool bar with some really simple step in to your office app(word/outlook/excel etc.). So here we go:
1. Go to menu: tools->Customize… => it will open Customize window.
2. In Customize window go to Toolbars tab and click on “New…” button. It will open a small window here you need to give toolbar name.
3. Your toolbar is ready to add.
4. You can drag buttons from Customize window’s Command tab.
5. For ex. in Command tab select ‘File’ at left pane and drag ‘Open’ in right pane to the newly created toolbar. Its done.

You can also add previously created macro in to this toolbar.

Hiding grid lines in Excel

This was the thing i want to do in excel. Hiding all the grid lines and showing only tables which i have created.

Hiding grid lines:

1.  Go to tools-> Options… Menu

2. It will show Options dialog box.

3. Go to View tab.

4. In view tab, at down Window Options part, uncheck Gridlines checkbox.