Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cell Locking

Cell Locking

ResolvedVersion 2007

Fri 10 Dec 2010, 16:21 Delegate Annie said...

Annie has attended:
Excel Intermediate course
Excel Advanced course

Cell Locking

Is there a way that you can identify which cells are locked on a spreadsheet if you have locked a selection of cells but you are unable to remember how many you locked?

Sun 12 Dec 2010, 21:56 Trainer Simon said...

RE: Cell Locking

Hi Annie,

Thank you for your question and welcome to the forum.

As far as I am aware there is no direct method in identifying locked cells.

It would have to be done using in a Macro written in the Excel VBA window.

Regards

Simon

Sun 19 Dec 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips

Cell Locking

Cell Locking

RE: Cell Locking

Excel articles

Excel tip:

Customize the toolbar in Excel 2010