Hi,

I am building a spreadsheet which has an external query which should
refresh when a parameter changes.

The sheet is being used as a form by users so I want to protect the
sheet and have the query hidden - the query result feeds valid entries
on another cell.

The problem I have is that, with the query setup to refresh when the
paramter changes, it is unable to do so as the sheet is protected.

Can anyone tell me the vb I can use to unprotect the sheet, refresh the
query, then protect the sheet when a particular value changes.

Note that there are multiple cells and queries on the same sheet that I
need to be able to do this with.

Many thanks,

Gavin



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/