Toggle read only
 

In the old excel, I put a "toggle read only" button on the task bar.
Clicking it made the current spreadsheet read only; clicking again made it
read-write again.

The new excel has the same icon, but it won't toggle. Clicking it makes the
current spreadsheet read only; but clicking again, I get a message that the
current file is locked for editing by another user.

How can I get it to work the way it used to????

Toggle read only
 

Hi Lesliec4000

I test it with a xls and xlsm file in 2007 after adding the Toggle Read Only button to the QAT
and it is working for me

--

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




"Lesliec4000" wrote in message ...
In the old excel, I put a "toggle read only" button on the task bar.
Clicking it made the current spreadsheet read only; clicking again made it
read-write again.

The new excel has the same icon, but it won't toggle. Clicking it makes the
current spreadsheet read only; but clicking again, I get a message that the
current file is locked for editing by another user.

How can I get it to work the way it used to????

Toggle read only
 

Ron, What does QAT mean? Thanks.

"Ron de Bruin" wrote:

Hi Lesliec4000

I test it with a xls and xlsm file in 2007 after adding the Toggle Read Only button to the QAT
and it is working for me

--

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




"Lesliec4000" wrote in message ...
In the old excel, I put a "toggle read only" button on the task bar.
Clicking it made the current spreadsheet read only; clicking again made it
read-write again.

The new excel has the same icon, but it won't toggle. Clicking it makes the
current spreadsheet read only; but clicking again, I get a message that the
current file is locked for editing by another user.

How can I get it to work the way it used to????

Toggle read only
 

I add the Toggle Read Only button to my QAT = Quick Access Toolbar

See how to add it here
http://www.rondebruin.nl/notinribbon.htm

The name = Toggle Read Only

--

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




"Lesliec4000" wrote in message ...
Ron, What does QAT mean? Thanks.

"Ron de Bruin" wrote:

Hi Lesliec4000

I test it with a xls and xlsm file in 2007 after adding the Toggle Read Only button to the QAT
and it is working for me

--

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




"Lesliec4000" wrote in message ...
In the old excel, I put a "toggle read only" button on the task bar.
Clicking it made the current spreadsheet read only; clicking again made it
read-write again.

The new excel has the same icon, but it won't toggle. Clicking it makes the
current spreadsheet read only; but clicking again, I get a message that the
current file is locked for editing by another user.

How can I get it to work the way it used to????