News

Fortunately, Excel provides built-in features that allow you to hide and password-protect your worksheets without requiring any programming skills. Password Protecting Excel Spreadsheet Data ...
Excel has three levels of worksheet visibility: visible, hidden, and very hidden. While many people know about hiding and unhiding worksheets by right-clicking the tab area at the bottom of the ...
Password-Protected Macros Open the Excel worksheet where you wish to place the macro and then activate the Visual Basic for Applications options by turning on the Developer tab.
Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.
This is the demonstration file to accompany the article, Hide everything but the working area in an Excel worksheet by Susan Harkins.