Date Expire and Password Protect Your Excel Project
- Comments Off
When building your Excel projects, you may want to demo a trial version of the work you have completed without giving full access to the working program. There are a couple things you can do to the project to make it difficult to access the vba code you have created. In addition to that, we’ll […]
How to Stop Excel from Flickering during Macros
- Comments Off
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 […]
Writing a Macro
You may have heard a macro as being referred to also as a sub or subroutine, but any way you phrase it, it is a set of instructions in VBA used to perform an action. Using macros in Excel will greatly enhance your Excel experience and open up many possibilities through flexibility and speed. In […]
Is VBA in Excel 2007 Slower Than in Excel 2003?
- Comments Off
The Microsoft Excel Blog has an interesting post about the speed of Excel 2007′s VBA. Apparently it has come to their attention that in some cases the VBA in Excel 2007 is not running as quick as its 2003 predecessor. I personally have not come across an instance where this has happened, but apparently many Excel 2007 users have. The blog […]