ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting a worksheet so it cant be unhidden (https://www.excelbanter.com/excel-discussion-misc-queries/30215-protecting-worksheet-so-cant-unhidden.html)

ynissel

Protecting a worksheet so it cant be unhidden
 
I have a hidden worksheet in a protected worksheet. Is there anyway to not
allow someone to unhide it ?
Thanks !

Peo Sjoblom

There is no way of hiding it for someone that can search the internet


Regards,

Peo Sjoblom



"ynissel" wrote:

I have a hidden worksheet in a protected worksheet. Is there anyway to not
allow someone to unhide it ?
Thanks !


Jonathan Cooper

In other words, you can hide and protect it from the average user, but a
determined user that searches the internet can find a way to unhide it.

For the average user, FORMAT--SHEET--HIDE.

Then TOOLS--PROTECTION--PROTECT WORKBOOK.

"Peo Sjoblom" wrote:

There is no way of hiding it for someone that can search the internet


Regards,

Peo Sjoblom



"ynissel" wrote:

I have a hidden worksheet in a protected worksheet. Is there anyway to not
allow someone to unhide it ?
Thanks !



All times are GMT +1. The time now is 06:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com