ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Help! How to Remove Read Only Status on a Worksheet (https://www.excelbanter.com/excel-worksheet-functions/133824-help-how-remove-read-only-status-worksheet.html)

Leslie at the Bank

Help! How to Remove Read Only Status on a Worksheet
 
I have put a read-only status on several files--so different branches can
look at but not change. I think I should have just password-protected them
instead. I'd like to remove read only status on the files instead of copying
them to different locations---does anyone know how I can do this?
Thanks.

Gord Dibben

Help! How to Remove Read Only Status on a Worksheet
 
Open the workbook and FileSave AsToolsGeneral Options. Uncheck the "read
only recommended" and re-save.

"Password-protected" at which level?

Sheet-protection?

ToolsProtectionProtect Sheet.

Note: Excel's internal security on sheets and workbooks is very weak, but will
keep the un-sophisticated user from cracking your password.


Gord Dibben MS Excel MVP



On Wed, 7 Mar 2007 11:06:08 -0800, Leslie at the Bank <Leslie at the
wrote:

I have put a read-only status on several files--so different branches can
look at but not change. I think I should have just password-protected them
instead. I'd like to remove read only status on the files instead of copying
them to different locations---does anyone know how I can do this?
Thanks.




All times are GMT +1. The time now is 03:47 PM.

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