Locking down worksheets

[Guest]

Ok, we have a very complicated spreadsheet that we send pricing info out to a
customer that allows them to plug in their info and all the specs and get our
current price...

Right now we have all the cells locked and hidden execpt for the ones
required for them to fill in... what my issues is that people found out they
can still copy and entire sheet and paste it into another sheet and then
bypass the locks and stuff, then they also can go through and right lookups
to view the information on the hidden sheets that we have in there as well.

My question is, is there away to stop this from happening? Thank you

 

[PC]

Not really.

However, if you put the data tables in a web database and use PHP (server
side) to generate a results page and a macro to send the query inputs and
import the results you could get the security you are looking for.

PC