Look Who it Was Random video

How to create macro in Personal workbook

342 views · Published 16 August 2015 · 7:38 · Indexed 11 October 2026

Channel: Krishna S · 2015 · Science & Technology

Watch on YouTube

How to customize Excel Ribbon with User Macros. 

Add your own command into excel ribbon. Record a macro as Personal Macro Workbook. By doing this you get your macro available for entire Excel.

To add custom command to ribbon

Click the File tab.

Under Help, click Options.

Click Customize Ribbon.

Add a custom tab

When you click New Tab, you add a custom tab and custom group. You can only add commands to custom groups.

In the Customize the Ribbon window under the Customize the Ribbon list, click New Tab.

To see and save your customizations, click OK.

To add commands to a custom group, see the Add commands to a custom group section.

Rename a default or custom tab

In the Customize the Ribbon window under the Customize the Ribbon list, click the tab that you want to rename.

Click Rename, and then type a new name.

To see and save your customizations, click OK.

Hide a default or custom tab

You can hide both custom and default tabs, but you can only remove custom tabs.

In the Customize the Ribbon window under the Customize the Ribbon list, clear the check box next to the default tab or custom tab that you want to hide.

To see and save your customizations, click OK.



Subscribe to my channel:
http://www.youtube.com/user/krishnayess?sub_confirmation=1
YouTube Channel: https://www.youtube.com/krishnayess
My Blog: http://krishnasr.blogspot.in/
Google Plus: https://plus.google.com/+KrishSanj/
https://www.facebook.com/Office100

More from this channel