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 menu: Format > Sheet > Hide. To unhide, you just need to select Format > Sheet > Unhide and select the sheet you want to see. As you can see, that method is not very secure. Now we will go over a second method to more permanently hide worksheet.
Read More
Calculate Age in Excel
Using a combination of built-in functions in Excel, you can quickly calculate a person’s age. There are a couple different ways this method can be used, and we’ll go through both below.
Read More
Excel Keyboard Shortcuts from Microsoft
A few years ago, I wrote a post listing many of the keyboard shortcuts that are available in Microsoft Excel. They included anything from copy & paste shortcuts to formatting shortcuts that could increase your productivity within Excel. Well it looks like Microsoft has posted a printer-friendly list of Excel shortcuts for you to use.
Read More
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 look at how to add vba code to disable the project from opening.
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.
