| 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 |
| 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)
Threaded Mode
