| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update Excel locked cell
Using VBA, how can I update (write) to a locked cell in a
worksheet? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update Excel locked cell
use the userinterfaceonly property of the protect method. When this is set
to True, the sheet can remain protected and your code can write to the sheet. -- Regards, Tom Ogilvy "Jim Carlin" wrote in message ... Using VBA, how can I update (write) to a locked cell in a worksheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locked cell not locked | Excel Discussion (Misc queries) | |||
| Excel 2003 -- position locked--anchored to a cell?? | Excel Discussion (Misc queries) | |||
| Is there a way to enter a comment on a locked cell in Excel? | Excel Worksheet Functions | |||
| How can I allow users to update a pivot table when it is locked? | Excel Discussion (Misc queries) | |||
| In excel, I seem to be "locked" on a cell and unable to click off. | Excel Discussion (Misc queries) | |||
Hybrid Mode
