How to Make a Worksheet Very Hidden
Today we will review two ways that you can hide a worksheet in your workbook. The simple way is very easy for the end user to unhide the worksheet; the same spreadsheet that you didn’t want them to see in the first place. To hide a worksheet this way, just select from the main [...]
Date Expire and Password Protect Your Excel Project
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 Use Your Personal Macro Workbook
For any of the repeating tasks that you do through macros, Excel provides a way to have those commonly used actions always available to you. Instead of copying the macros you use frequently to every workbook, Excel gives you use of a Personal Macro Workbook.
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 [...]
