Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Across a worksheet, which cells I have formatted as locked?
How do I tell which cells I have formatted as locked in an excel worksheet
without looking at each one individually? |
#2
|
|||
|
|||
Across a worksheet, which cells I have formatted as locked?
With the sheet protected, you should only be able to Tab into the unlocked
cells. -- Ian -- "ZM" wrote in message ... How do I tell which cells I have formatted as locked in an excel worksheet without looking at each one individually? |
#3
|
|||
|
|||
Across a worksheet, which cells I have formatted as locked?
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" wrote in message ... How do I tell which cells I have formatted as locked in an excel worksheet without looking at each one individually? |
#4
|
|||
|
|||
Across a worksheet, which cells I have formatted as locked?
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" wrote in message ... 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" wrote in message ... How do I tell which cells I have formatted as locked in an excel worksheet without looking at each one individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
Viewing LOCKED cells | Excel Discussion (Misc queries) | |||
How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |