If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find & Replace within Unlocked Cells in a Protected Worksheet | DaveyC4S | General Discussion | 2 | October 9th, 2005 11:12 AM |
Using formatted cells in formulas | Frank Marousek | General Discussion | 3 | June 7th, 2005 08:09 PM |
Unlocking Cells when a worksheet is protected... | racmb1975 | General Discussion | 2 | May 3rd, 2005 08:57 PM |
Trace Auditing Pointing to Dependent Cells in a Different Worksheet | cayo0734 | General Discussion | 1 | October 2nd, 2004 04:30 PM |
Can't Sort Worksheet - Merged Cells Must be Identically Sized | Setting up and Configuration | 1 | February 4th, 2004 02:18 AM |