ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to hide raws and use password (https://www.excelbanter.com/excel-worksheet-functions/68805-how-hide-raws-use-password.html)

speedo

how to hide raws and use password
 
Hi there,
could you let me know how to hide chosen raws and impose a certain password
on that - is that possible?
Rgs.
Moris



Mich modulus 11

how to hide raws and use password
 


"speedo" wrote:

Hi there,
could you let me know how to hide chosen raws and impose a certain password
on that - is that possible?
Rgs.
Moris


You can protect the spreadsheet so that the rows can't be unhidden after
you've hidden them. You will need to identify which areas of the worksheet
you want ot be available for data entry, do format cells, protection, and
uncheck the locked box. Then click on the tool bat, tools, protection.
protect sheet, password.



All times are GMT +1. The time now is 10:14 AM.

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