External Data and Sheet Protection

N

nbs

I have a sheet that runs automatic external web and
database queries...I need to protect the sheet from user
changes but when I do the automatic updates are not
permitted either. Is there a way to permit auto updates
and prevent user changes a the same time? THANKS.
 
D

Dave Peterson

Untested:

Maybe you could have your query put its data in another sheet (hidden, but
unprotected).

Then use formulas to return the values to the user's worksheet.
 
Top