Locking down worksheets
 

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

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


"Toby" wrote in message
...
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