ExcelBanter - password protect one sheet in within file

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - password protect one sheet in within file (https://www.excelbanter.com/excel-programming/317702-password-protect-one-sheet-within-file.html)

DSK_7[_2_]

password protect one sheet in within file

Is it possible to password protect one or more sheets in a workbook but leave
the rest viewable?

(the password will be required to view the sheet).

Thanks,
DSK

GAZZAT5[_3_]

password protect one sheet in within file

you could protect the sheet and hide all the cells (or just lock the
all), or hide the sheet

--
GAZZAT
-----------------------------------------------------------------------
GAZZAT5's Profile: http://www.excelforum.com/member.php...fo&userid=1680
View this thread: http://www.excelforum.com/showthread.php?threadid=32007

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