How do I tell which cells I have formatted as locked in an excel worksheet
without looking at each one individually?
How do I tell which cells I have formatted as locked in an excel worksheet
without looking at each one individually?
With the sheet protected, you should only be able to Tab into the unlocked
cells.
--
Ian
--
"ZM" <[email protected]> wrote in message
news:[email protected]...
> How do I tell which cells I have formatted as locked in an excel worksheet
> without looking at each one individually?
Thank you I hadn't thought of that. The file however is rather complex and it
would still take a lot of time to tab round all the unlocked cells. Is there
any way of viewing the whole sheet in one go?
"Ian" wrote:
> With the sheet protected, you should only be able to Tab into the unlocked
> cells.
>
> --
> Ian
> --
> "ZM" <[email protected]> wrote in message
> news:[email protected]...
> > How do I tell which cells I have formatted as locked in an excel worksheet
> > without looking at each one individually?
>
>
>
Colours locked cells yellow:
Sub colourlockedcells()
For c = 1 To 10
For r = 1 To 10
If Cells(r, c).Locked = True Then
Cells(r, c).Interior.ColorIndex = 6
End If
Next r
Next c
End Sub
Returns coloured cells back to "clear". It will also clear any existing cell
colours.
Sub clearcolouredcell()
For c = 1 To 10
For r = 1 To 10
Cells(r, c).Interior.ColorIndex = 0
Next r
Next c
End Sub
--
Ian
--
"ZM" <[email protected]> wrote in message
news:[email protected]...
> Thank you I hadn't thought of that. The file however is rather complex and
> it
> would still take a lot of time to tab round all the unlocked cells. Is
> there
> any way of viewing the whole sheet in one go?
>
> "Ian" wrote:
>
>> With the sheet protected, you should only be able to Tab into the
>> unlocked
>> cells.
>>
>> --
>> Ian
>> --
>> "ZM" <[email protected]> wrote in message
>> news:[email protected]...
>> > How do I tell which cells I have formatted as locked in an excel
>> > worksheet
>> > without looking at each one individually?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks