hazarwi said:
......Nice..
But it this should repeat for every workbook otherwise formula will not work.
follow these for to stay permanent till office installation remains.
1. when copy code in module then dont press Alt+q, Go to file menu and select save workbook.
in the popup window select file type as: Excel Ad-In (for office 2007 or abov)
Excel 97-2003 Ad-In (for office xp or 2003)
Save file.
2. Now go to option/Settings in Ad-Ins select your currently save ad-In and click ok
Now you can use your formula in every workbook old or new. it will work till your office Installation Remains.
That's sound great. Thank you for sharing with us.
Well done.
[IMG]http://i445.***********.com/albums/qq172/soni_006/th_Ryu-3.gif[/IMG]
Bookmarks