ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to make a worksheet uneditable? (https://www.excelbanter.com/excel-programming/299613-how-make-worksheet-uneditable.html)

Pop

How to make a worksheet uneditable?
 
Dear all,
I wonder how to make a worksheet uneditable?
I don't want to let the user edit a particular
worksheet,I just wanna let them views the data only.

Thank you first! (",)

Charles

How to make a worksheet uneditable?
 
Pop,

Protect the worksheet.
Tools,protect sheet. assign a password

Charle

--
Message posted from http://www.ExcelForum.com


Jon Peltier[_7_]

How to make a worksheet uneditable?
 
Takes about a second to unlock using code that's appeared in these forums.

Another suggestion is to turn it into a PDF file. Adobe's rather costly,
do a google search for CutePDF.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Charles < wrote:

Pop,

Protect the worksheet.
Tools,protect sheet. assign a password

Charles


---
Message posted from http://www.ExcelForum.com/




All times are GMT +1. The time now is 11:19 PM.

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