Link Chart 3


Download the file from here see Link Chart 2 see Link Chart 1 Thanks Rajan

Calling UDFs by Hyperlink


So you are creating a dashboard and you are in a deep thought , thinking what should I add to make it more interactive You have added scroll bar, dropdowns to refresh your charts and all what you can do with the excel, but may time you feel like there should be a mouse hover…

Indexer


hi Guys, it took my lot of time to create home/Index tab to navigate in excel workbook, i always need it in most of dashboards ,dont you? You can set any shape style default by right click on the shapes, it will work accordingly.   here is the code to create index :  Sub CreateIndex()…

Change Hyperlink Screentip


It may take lot of time to change screen tip of each hyperlink in Excel, here is a code can do in few seconds here you go : Sub ChangeHyperLinkSceenTipOnAllShape()     ‘—————————————–     ‘–This Procedure will change screenTip     ‘  of Cells and Shapes in ActiveSheet     ‘—————————————–     Dim…