ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting Worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/126567-protecting-worksheets.html)

Kaitlin.uk

Protecting Worksheets
 
I have multiple worksheets in one workbook. Can i protect just one worksheet
within the book so that it cannot be viewed at all.

so when you click on the tab it asks for a password? instead of just
protecting all the cells?

thanks

ufo_pilot

Protecting Worksheets
 
You can hide the sheet
FormatSheetHide
then password - protect the workbook


"Kaitlin.uk" wrote:

I have multiple worksheets in one workbook. Can i protect just one worksheet
within the book so that it cannot be viewed at all.

so when you click on the tab it asks for a password? instead of just
protecting all the cells?

thanks



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

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