ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   where is tthe "read only" TOGGLE button ? (https://www.excelbanter.com/excel-worksheet-functions/256629-where-tthe-read-only-toggle-button.html)

Kee

where is tthe "read only" TOGGLE button ?
 
HI i often open a file and leave open as a read only file , and whenever i
edit a cell , i click on the "read only " toggle button then key in the
password and then save the file , then click on "read only" again and the
file is read only again, i dont have to close and reopen the file to make
changes to any cell, so how to do this with Excel 2007 ?
appreciate a lot to all who answered ,
thank you

Ron de Bruin

where is tthe "read only" TOGGLE button ?
 
Hi Kee

You can add this button to the QAT
http://www.rondebruin.nl/notinribbon.htm

The name = Toggle Read Only


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kee" wrote in message ...
HI i often open a file and leave open as a read only file , and whenever i
edit a cell , i click on the "read only " toggle button then key in the
password and then save the file , then click on "read only" again and the
file is read only again, i dont have to close and reopen the file to make
changes to any cell, so how to do this with Excel 2007 ?
appreciate a lot to all who answered ,
thank you



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

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