«

»

Feb 19

#1:Creating Excel menus using your Sub Routine

#1:Creating Excel menus using your Sub Routine- Excel Intermediate Level

Solution: 

1. First make sure which Sub Routine you want to add it in a menu 

2. Click > File > Options> Customize Ribbon

3. Now from the Right side Panel > Click New Tab and Name it Properly 

4. From Choose Commands from drop down bar > Select Macros and Pick your macro  

5. Now if you press add it will be added to the New Group > Press OK 

6. Your Sub Routine will now appear on the menu 

Benefits: 

1. Build your own menus On The Go

2. Easy to execute 

NB: If you send your Excel file to some one they cannot see your menu. 

Alternatively you can watch my below video for better understanding. 

If the video is not visible please click here. 

Please leave your comments below if this tip is useful

About the author

Ragavan Rajan

I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">