| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Define list of worksheets | Excel Worksheet Functions | |||
| Spawning worksheets and a summary per worksheet | Excel Discussion (Misc queries) | |||
| How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| How to view tiled Excel worksheets by locking rows for scrolling . | Excel Worksheet Functions | |||
Threaded Mode
