ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can user move in locked worksheet but not copy cell contents? (https://www.excelbanter.com/excel-worksheet-functions/85210-how-can-user-move-locked-worksheet-but-not-copy-cell-contents.html)

PAT

How can user move in locked worksheet but not copy cell contents?
 
I have password protected a worksheet. I have checked the locked and
unlocked boxes so that the viewer can move around in the WS and view
formulas,etc. However, I attempted to copy a cell to a new WS and Excel 2002
let me do so. How do I prevent this copy function?
--
PAT


All times are GMT +1. The time now is 12:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com