| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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???? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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???? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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???? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I toggle in and out of read-only status in an Excel file? | Excel Discussion (Misc queries) | |||
| Need to Use 1 Button to toggle On or Off | Excel Discussion (Misc queries) | |||
| Toggle between worksheets | Excel Worksheet Functions | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
Hybrid Mode
