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

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