| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How change unprotected cell formats on protected worksheets?
I have a protected worksheet that allows users to manually input into
unprotected ranges, or manually copy from a protected range into an unprotected area. Copy from cells have different font and background colors that change the destination cell formats after paste even when sheet is protected. How do I restore the color formats of the destination cells after the changes are processed by an executed macro? The following works fine if sheet is unprotected, but gives error 1004 if protected: Range("destname").Interior.ColorIndex = 35 Range("destname").Font.ColorIndex = 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to highlight an unprotected cell on a protected sheet. | Excel Worksheet Functions | |||
| Adding comments to unprotected cell in a protected sheet | Excel Discussion (Misc queries) | |||
| adding comments to unprotected cell/range in protected worksheet | Excel Worksheet Functions | |||
| TAB and focus moving from unprotected cell in protected sheet til dropdown. | Excel Programming | |||
| CELL PROTECTED IN 2000, UNPROTECTED IN 2003 | Excel Worksheet Functions | |||
Threaded Mode
