| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
locked cells and code
If cells are 'locked' I have found that data which is supposed to be
inserted by code isn't. Is there a way around this? -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
locked cells and code
The code needs to unprotect the worksheet before updating the cells and, if
required, protect the worksheet after updating the cells. Jock wrote: If cells are 'locked' I have found that data which is supposed to be inserted by code isn't. Is there a way around this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200708/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
locked cells and code
Thanks to Trevor & Mike
-- Traa Dy Liooar Jock "Trevor via OfficeKB.com" wrote: The code needs to unprotect the worksheet before updating the cells and, if required, protect the worksheet after updating the cells. Jock wrote: If cells are 'locked' I have found that data which is supposed to be inserted by code isn't. Is there a way around this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200708/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
locked cells and code
Jock,
Unprotect make you changes and then reprotect at runtime Sub standard() ActiveSheet.Unprotect Password:="Mypass" 'Make your changes ActiveSheet.protect Password:="Mypass" End Sub Mike "Jock" wrote: If cells are 'locked' I have found that data which is supposed to be inserted by code isn't. Is there a way around this? -- Traa Dy Liooar Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
| I want the macros to be locked up when cells are locked up. | Excel Programming | |||
| need code for disable selection of locked cells | Excel Programming | |||
| Locked workstation breaks code? | Excel Programming | |||
Hybrid Mode
