Protecting ranges that may be copied

R

Rich Wallach

I've embedded a database query in a worksheet. Because
the data being retrieved is senstive, I've hidden the
paramter ranges and password protected the worksheet.

Unfortunately, a clever user can just copy the whole sheet
into a new workbook and the password protection is
defeated. The parameter ranges can be unhidden and the
query pointed elsewhere.

Can anyone tell me if there is a way to defeat this
behavior?
Thanks in advance,
Rich
 
Top