Need For Excel|Blogs

Create a Table Of Contents With Hyperlinks In Excel Using VBA

Want to generate a Table of Contents or an Index as some may call it in your Excel workbook? It isn't as tough as it may seem at first. Put the below code in a standard code module and then execute. The code will generate a new sheet called Index, and generate an Index or a Table Of Contents with working Hyperlinks to all the worksheets. ------------------------------------------------------------------------------------- Sub HyperlinkWorksheetNames() 'Code by Deep Dave, make

Unhide All Hidden Worksheets At Once

If you have a workbook with many hidden worksheets, you cannot unhide all of them at once, UNLESS, you use the below VBA Code.. ------------------------------------------------------------------ Option Explicit Sub UnHideAllSheets() 'Unhides All Worksheets Dim Sheet As Worksheet Application.ScreenUpdating = False For Each Sheet In ActiveWorkbook.Worksheets Sheet.Visible = xlSheetVisible Next Sheet Application.ScreenUpdating = True En

Reset All Slicers At Once

Slicers were a great introduction in the Excel 2010 Version. They work really really well with Pivot Tables to help you slice and dice your data very quickly. However, if you deal with quite a few slicers on a report, you surely must have observed that currently there is no way you can reset all slicers at once. If you have 10 slicers on a report, you have to clear all 10 of those one after the other, which is very annoying. Hence, I had to ask VBA for some help! Put the belo

Macro To Add Transparent Rectangle On Active Cell

The following code will generate a Transparent Rectangle with Red Border on the Active Cell, when executed. Put the below code on the Personal Macro Workbook to have it available on all Excel Workbooks on your computer. __________________________________________________________ Sub AddRectangle() 'Macro By Deep Dave on 21st Nov 2014 (www.NeedForExcel.com) 'Macro creates a Rectangle with a Red Border Application.ScreenUpdating = False 'Turns off screen updating D

Enable Developer Tab

To work with the Macro Recorder or VBA (Visual Basic For Applications) you need to enable the Developer Tab first. This is how you do it - For 2007 Version - Click on the Office button on the Left top corner Select Excel Options On the Popular Tab, check the box in front of “Show Developer tab in the ribbon” For 2010/2013 Version - Click on the File Tab Select Options Select Customize Ribbon Check the box in front of “Developer” Interested in learning how to use the Macro Rec

Enable Developer Tab

Follow Us