VBA – Macros

Home/VBA – Macros

 Removing Macros

Removing Macros Q: I have an Excel file and for some reason, every time I open it, it asks me if it's OK to run macros ... but there aren't any! How do I stop this annoying message from appearing? By Jeff Robson This message means that somewhere in your file there must be [...]

 Speeding Up Print Macros

Speeding up Print macros I have recorded a macro that changes print settings and then prints various sheets. The problem is that it takes a while to run. Is there a way to speed it up? By Neale Blackwood When you record macros Excel creates the VBA code for you. This is really useful [...]

 Speeding Up Macros – Calculation

Speeding up macros - calculation Stop Excel calculating By Neale Blackwood One technique to speed up macros is to turn off Excel's automatic calculation at the beginning of your macro and then turn it back on at the end of your code. If you then need the spreadsheet to calculate during your code there [...]

 Protecting Sheets In Excel 2013 Is Slow

Protecting Sheets in Excel 2013 is Slow By Wyn Hopkins Protecting sheets takes much longer in Excel 2013 than it did in previous Excel versions. It’s not noticeable when you’re manually protecting a sheet, but if you have code that protects or unprotects sheets repeatedly, it can become a performance issue. For example, protecting [...]