A Better Way


A BETTER WAY
I was surprised by the interest generated by a recent item on ways to hide a worksheet (“ Technology Q&A, JofA , Nov. 06, page 83). But on reflection, I can see why: Confidentiality is important. That is why I selected two submissions that were especially effective and relatively simple to implement.

Owen Sargent, a CPA with Nussbaum Yates & Wolpow in Melville, N.Y., suggested changing the color of the data you want hidden from its normal black to white, making it invisible because of the white background. Then, to stop someone from changing the data back to black, click on Tools , Protection , Protect Sheet (or Workbook ) and that will bring up Protect Sheet (see screenshot below).

Select what actions other users can make on the worksheet and click. Pick a password, then click on OK .

To make that method still more secure, go to Tools , Options and under the View tab unclick the box at Formula bar (see screenshot below), thereby preventing a user from seeing data or a formula in the Formula bar .

Then, for even greater security, remove the sheet’s headers and line numbers. This prevents anyone from noticing anything is missing.

David Attaway, CPA, finance director of RBC Insurance, Greenville, S.C., suggested a somewhat more sophisticated method that works if you want to hide an entire worksheet, rather than just data in individual cells. His idea should stump all but highly skilled Excel users. Start by right-clicking on the tab name of the worksheet you want to hide and select View Code (see screenshot below).

This will open Visual Basic (VBA) for Excel (see screenshot below). In the Properties window, the last property is Visible . Click on 2-xlSheetVeryHidden . Now even if the user selects Format , Sheet , Unhide , the tab won’t appear there. The only way to unhide it is to reopen VBA and change the property back.

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out