ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Worksheet Protection (https://www.excelbanter.com/excel-programming/355091-worksheet-protection.html)

grahammal[_22_]

Worksheet Protection
 

Is there any way to Protect just part of a Spreadsheet rather than all
of it.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=518963


Ron de Bruin

Worksheet Protection
 
Hi grahammal

By default all cells are locked on a sheet

Select the cell you want to edit
FormatCells protection
Uncheck locked

Protect your sheet now


--
Regards Ron de Bruin
http://www.rondebruin.nl


"grahammal" wrote in message
...

Is there any way to Protect just part of a Spreadsheet rather than all
of it.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=518963





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

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