<div>
Not to be gay or anything... haha
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a script written that hides blank cells to generate a nice looking invoice, the only problem is currently I have to press a button to run it. What I would like to do is have the macro execute every time I open up the sheet 'Invoice'. Invoice is made up from data in other sheets. If someone could help me with this it would be greatly appreciated. Thanks!
</div>
</div>


Hello,

I have a script written that hides blank cells to generate a nice looking invoice, the only problem is currently I have to press a button to run it. What I would like to do is have the macro execute every time I open up the sheet 'Invoice'. Invoice is made up from data in other sheets. If someone could help me with this it would be greatly appreciated. Thanks!

I need a macro to run every time I swtich to a particular worksheet.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.