| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error changing protected cell
I have macros that run BeforeSave. My sheets are protected, but I run a
routine first that disables events and unprotects them all. I still get an error that I am trying to change a protected cell. While debugging, I query the worksheet.protection mode and it says FALSE. I even tried to unlock/lock the cells and it won't let me do that either. What am I missing here? InTHANKSadvance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error changing protected cell
is the workbook protected?
"Jim Zeeb" wrote: I have macros that run BeforeSave. My sheets are protected, but I run a routine first that disables events and unprotects them all. I still get an error that I am trying to change a protected cell. While debugging, I query the worksheet.protection mode and it says FALSE. I even tried to unlock/lock the cells and it won't let me do that either. What am I missing here? InTHANKSadvance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error changing protected cell
I checked ActiveWorkbook.ProtectStructure and .ProtectWindows and they are
both FALSE ....jz "Philip" wrote: is the workbook protected? "Jim Zeeb" wrote: I have macros that run BeforeSave. My sheets are protected, but I run a routine first that disables events and unprotects them all. I still get an error that I am trying to change a protected cell. While debugging, I query the worksheet.protection mode and it says FALSE. I even tried to unlock/lock the cells and it won't let me do that either. What am I missing here? InTHANKSadvance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error changing protected cell
Try looking at the worksheets("sheet1").protectcontents status.
..protectionmode doesn't check what you want. One the other hand, if you protect the worksheets in code with userinterfaceonly:=true, then your code can change things that users can't. (.protectionmode checks this setting.) Jim Zeeb wrote: I have macros that run BeforeSave. My sheets are protected, but I run a routine first that disables events and unprotects them all. I still get an error that I am trying to change a protected cell. While debugging, I query the worksheet.protection mode and it says FALSE. I even tried to unlock/lock the cells and it won't let me do that either. What am I missing here? InTHANKSadvance -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format changing in protected cell | Excel Discussion (Misc queries) | |||
| Changing Font in an unlocked cell in a protected sheet. | Excel Discussion (Misc queries) | |||
| Getting protected cell error message when calculating (F9) | Excel Programming | |||
| Protected cell error - Excel XP & Win98 | Excel Programming | |||
| Cell Protected Error | Excel Programming | |||
![Jim Zeeb[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
