<div>
Used VBA and chose the VeryHidden option for that page and it did what I needed. &nbsp;No one else uses VBA so they shouldn't be able to unhide themselves. &nbsp;I never new that existed. &nbsp;Learn something new everyday. &nbsp;<br />
Thanks
</div>


Used VBA and chose the VeryHidden option for that page and it did what I needed.  No one else uses VBA so they shouldn't be able to unhide themselves.  I never new that existed.  Learn something new everyday.  
Thanks

<div>
You can also protect the &quot;project&quot; with a password keeping them out of the code as well.<br />
<br />
From the tools menu in the editor,<br />
go to VBAProject Properties, select the Protection tab, select &quot;Lock project for viewing&quot;, then enter &amp;&nbsp;confirm your password in the fields provided, and click OK.
</div>


You can also protect the "project" with a password keeping them out of the code as well.

From the tools menu in the editor,
go to VBAProject Properties, select the Protection tab, select "Lock project for viewing", then enter & confirm your password in the fields provided, and click OK.

<div>
<div class="content wysiwyg-content">
I have a worksheet that pulls data (using external data) from a SQL database. &nbsp;In the same worksheet I have a sheet that pull data from a Access database. &nbsp;The SQL sheet has confidential info on it that I want to be able to hide the data or sheet from anyone being able to see it. &nbsp;On the Access sheet I have a Vlookup that is pull info from the sheet I want hidden, but when I hide and protect it won't let me refresh all because it say the data is Read Only. &nbsp;Is there anyway to get the results I want.<br />
Thanks
</div>
</div>


I have a worksheet that pulls data (using external data) from a SQL database.  In the same worksheet I have a sheet that pull data from a Access database.  The SQL sheet has confidential info on it that I want to be able to hide the data or sheet from anyone being able to see it.  On the Access sheet I have a Vlookup that is pull info from the sheet I want hidden, but when I hide and protect it won't let me refresh all because it say the data is Read Only.  Is there anyway to get the results I want.
Thanks

Protect Hidden Sheet in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.