Reusing the Macros for all excel sheet

[nagovind]

Dear All,

We have created many macros for an excel sheet. How to retain it in a PC such that it will work for any open workbook.

It shall be in such a way that macros will not be embedded in all worksheets. So that Created macros will be PC based and not excel workbook based

Kindly advise

Regards
Govind

 

[Chihiro]

There are multiple ways to do it. Two most common ones are...

1. Create Excel Add-in.
http://www.ozgrid.com/VBA/excel-add-in-create.htm

2. Add code to Personal.xlsb
https://www.rondebruin.nl/win/personal.htm

etc.

 

[nagovind]

Hi Chihiro,

Creating Excel Addin helped a lot

Thank you very much