excel

[Jason Marino]

How can you tell when an excel spreadsheet is locked.

 

[navin]

How can you tell when an excel spreadsheet is locked.

when you say locking, is it protecting or freezing??

 

[Jason Marino]

I mean when a user tries to copy data from a cell and it wont allow
them. Is there away you can tell if the hole worksheet is locked so a
user cant copy and paste or do any work in it at all. The file is not a
read only.

 

[Gord Dibben]

You can see if sheet protection is enabled by looking at Tools>Protection.

If "Unprotect Sheet" is available then the sheet is protected but you still
won't know which cells are locked or not.

Note: if the workbook is shared, this method is not valid.

Shared workbooks don't allow sheet protection to be altered.

If you want to see which individual cells are locked or unlocked you need VBA
code.

If you want code, post back.

If you just want to make sure every cell is locked, unprotect the sheet and hit
CTRL + a(twice in 2003)

Format>Cells<Protection. Checkmark "locked"

Then re-protect the sheet.


Gord Dibben MS Excel MVP

 

[Ed Ferrero]

If you wish to see what cells are not locked, without using VBA...

Select the whole spreadsheet.

Use Format -> Conditional Formatting

Set condition as 'Formula Is', enter the formula =NOT(CELL("protect",A1)),
set the format as a pattern say red.

Ed Ferrero
www.edferrero.com