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

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.