K
Kent Klingler
I've developed a fairly simple spreadsheet for the purpose of collecting
information. In the worksheet are several pull-down lists created using the
data>validation>list function in Excel. Based on the selection in one of
pull-down, other pull-down list source ranges will be adjusted.
Everything works fine when the worksheet is unprotected, but when I protect
the worksheet I get the following error message:
Run-time error '1004';
Application-defined or object-defined error
The code generating the error is:
Range("B19").Validation.Modify xlValidateList, xlValidAlertStop, xlBetween,
"=$L$6:$L$12"
Cell B19 is a pull-down list created using the tool>validation function and
being adjusted using the above VBA statement and "=$L$6:$L$12" is the new
list source lookup range.
Any help with the problem will be appreciated.
Thanks in advance.
information. In the worksheet are several pull-down lists created using the
data>validation>list function in Excel. Based on the selection in one of
pull-down, other pull-down list source ranges will be adjusted.
Everything works fine when the worksheet is unprotected, but when I protect
the worksheet I get the following error message:
Run-time error '1004';
Application-defined or object-defined error
The code generating the error is:
Range("B19").Validation.Modify xlValidateList, xlValidAlertStop, xlBetween,
"=$L$6:$L$12"
Cell B19 is a pull-down list created using the tool>validation function and
being adjusted using the above VBA statement and "=$L$6:$L$12" is the new
list source lookup range.
Any help with the problem will be appreciated.
Thanks in advance.