Hello,
I'm trying to populate cells from a query where some cells are locked
and the cells I'm populating are unlocked.
However, when I run my macro, I get an error message telling me I can't
do anything w/o unprotecting the spreadsheet.
The macro DOES run if I unprotect the spreadsheet. What can I do to
keep users from modifying the form, but still be able to run the macro
by clicking a button.
FYI... the macro automatically locks unlocked cells after the query is
done. I don't understand why this happens.


---
Message posted from http://www.ExcelForum.com/