Adjust the Security Level in Excel
If you’ve ever used any Excel files that had macros included, you’ve probably come across the security settings in Microsoft Excel. There are multiple levels of security that Excel provides depending on your comfort level of running macros on your computer. Below we’ll look at how to change this setting and what each setting does.
How to Stop Excel from Flickering during Macros
If you’ve ever written or recorded a macro in Excel, you’ve no doubt noticed that it shows everything on the screen you tell it to do. Depending on the code, Excel will show different cell locations or even different worksheets being selected during run time. Below I’m going to show you a line of VBA [...]
Macro to Disable Cell Calculations on a Sheet
If you’ve ever had a sheet in your project that has a number of formulas with calculations, you’ve no doubt noticed the slowdown that occurs when saving your spreadsheet or editing a formula. Excel has a property that can be adjusted within a macro that allows you to turn on and off the calculations on [...]
Working with Userforms Part 1: Hello World! Button
Over the next few posts we will look at how to build a userform and put it to good use. Using a userform will provide additional functionality in your project that using the spreadsheet alone may not provide. One way to give your project that customized polished look, may be to incorporate the use of [...]
Run a Macro When Opening a Workbook
There may be a time when you want a macro to run automatically every time you open a workbook. Excel has a built in way to help with this – the Auto_Open subroutine (Workbook_Open achieves a similar result). Each time Excel opens, Auto_Open() will run only once when the workbook is open. Let’s go ahead [...]
Loading ...