VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

VBA Code To Determine If Outside Sheet References Exist In Cell Formulas

When you are trying to understand an unfamiliar workbook or Excel model, it can immensely help knowing which tabs are feeding into the one you are currently viewing. This little macro will give you a message box indicating any outside worksheet references found in the cell formulas of the ActiveSheet. 

Read More

Adjust Object Positioning Property To All Shapes & Images On Your Excel Worksheet

Adjust Object Positioning Property To All Shapes & Images On Your Excel Worksheet

Ever have an instance where you have a TON of shapes or images on your spreadsheet and you need to change the Object Positioning property for all of them?  It can be a hassle to individually select all the shapes on your spreadsheet (especially if you have a large amount) and tweak their object settings.

Read More