ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   about protect just cells (https://www.excelbanter.com/excel-discussion-misc-queries/1308-about-protect-just-cells.html)

tjtjjtjt

UnLock the cells you want to remain unprotected.
Select the cells you want to be editable. Then, Format | Cells | Protection.
Uncheck Locked.

tj

"hassan barjini" wrote:

hi everybody how can just protect cells not all the sheets?
just I want protect some cells not all the cells of a sheet .
best




Gord Dibben

Then you must enable sheet protection.

Gord Dibben Excel MVP

On Mon, 6 Dec 2004 06:19:06 -0800, "tjtjjtjt"
wrote:

UnLock the cells you want to remain unprotected.
Select the cells you want to be editable. Then, Format | Cells | Protection.
Uncheck Locked.

tj

"hassan barjini" wrote:

hi everybody how can just protect cells not all the sheets?
just I want protect some cells not all the cells of a sheet .
best





Peo Sjoblom

http://www.aspfaq.com/5005

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"hassan barjini" wrote in message
...
hi everybody how can just protect cells not all the sheets?
just I want protect some cells not all the cells of a sheet .
best




hassan barjini

about protect just cells
 
hi everybody how can just protect cells not all the sheets?
just I want protect some cells not all the cells of a sheet .
best




All times are GMT +1. The time now is 07:49 AM.

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