| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protected Formula Error
Eureka!
The problem is that Custom data validation was turned on (with no formula entered). Turn off data validation and the problem goes away. That leaves me with another puzzle. Using the menu commands, you cant set Custom validation without entering a formula, and I certainly didnt do it in a macro. Since my application was built from an inherited workbook, anything is possible. The smart tag flyover message on these cells that says, €śThis cell contains a formula and is not locked to protect it from being changed inadvertently€ť is a wonderful piece of half-truth that helps obscure the issue. Apparently the smart tags never heard of data validation. -- Al C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected formula error. | Excel Discussion (Misc queries) | |||
| 1004 Cell Protected Error for data validation lists when locked and protected | Excel Programming | |||
| Protected VB code - Run-time error | Excel Programming | |||
| Error 91 but only when sheet is protected | Excel Programming | |||
| Cell Protected Error | Excel Programming | |||
Hybrid Mode
