Prev: How to sum the number of times answered in a single column with b.
Next: Adding formula
From: Kee on 17 Feb 2010 21:48
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
From: Ron de Bruin on 18 Feb 2010 11:39
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" <Kee(a)discussions.microsoft.com> wrote in message news:9B248D74-A401-414A-BBE7-8D963184C8B2(a)microsoft.com...
> 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
 | 
Pages: 1
Prev: How to sum the number of times answered in a single column with b.
Next: Adding formula