| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection not allowing Validation
Please post the smallest sample that does not work.
Robert Flanagan Add-ins.com LLC http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel On Thursday, June 14, 2012 5:55:46 AM UTC-4, cosmmarchy wrote: Hi, I have a small piece of VBA which adds custom data validation on certain cells in my worksheet. These cells are not locked or hidden but when I protect the worksheet, this code does not work. There does not appear to be any options to allow this code to work when I protect the sheet and I do not have a password on it. Has anyone encountered this before? Could someone point me in the right direction? Many thanks -- cosmmarchy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - allowing only negative numbers or converting | Excel Discussion (Misc queries) | |||
| Protection not allowing Validation | Excel Programming | |||
| Data Validation Lists - Allowing no other entries | Excel Discussion (Misc queries) | |||
| Data Validation - Only Allowing certain characters | Excel Worksheet Functions | |||
| using protection (but allowing a combobox to still work) | Excel Programming | |||
![Bob Flanagan[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
