readonly toggle

[Chrissirhc]

Hi,

In Excel 2002 I can't find the option to toggle between read and readonly. Has it been removed? Or do you know where it is?

Thanks in advance,

Chris

 

[fumei]

Is there a toggle? If you are talking about actual file attributes, will you not need to use FileSystemObject to change them?

Gerry
My paintings and sculpture

 

[xlbo]

This is on the Save dialog menu in 2002 under Tools>General Options

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[fumei]

That is ReadOnly Recommended. It does not actually make the file read only. It just gives the person opening the file a choice to open it in readonly mode, or not. That is why I asked if the OP was talking about the file itself. And,....what toggle? Again, is there an actual toggle for this?

Gerry
My paintings and sculpture

 

[xlbo]

Gerry - kinda does if you put a password on it and don't tell 'em the password ;-) Admitedly, doesn't work for file manipulation but I assumed the user was wanting that property rather than any system properties

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Chrissirhc]

There was a read only toggle button that was in Excel 2000. You can get the button by looking in the commands menu as part of customize. It is very useful when you think "I don't want to close and open the workbook as readonly, but I want to make sure I don't save anything now because." I can't find it in Excel 2002....

 

[xlbo]

ooh - new shiny thing - didn't know about that. I am on 2003 and it is under:

View>Toolbars>Customise

COMMANDS tab

Highlight "File", scroll to the bottom et voila

(I have checked this on a coleague's machine on 2002 and it is in the same place there)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[fumei]

Indeed it is. A strange thing though. If you drag the toggle up onto a toolbar - so you can toggle - and make a new file...you can not toggle. It only toggles to read-only if you have already saved the file as recommended read-only. And if you have, and opened it as read-only, the toggle gives the same warning message as if you are opening it (again). If you haven't, and opened as NOT read-only, and toggle it to be read-only...you get the message again.

I don't doubt that this has some usefulness for someone, but I am not quite seeing myself.

Gerry
My paintings and sculpture

 

[GlennUK]

Gerry, you say:

I don't doubt that this has some usefulness for someone, but I am not quite seeing myself.

If you spend a lot of time in Read-Only mode, and often start correcting errors without realising your are still in Read-Only mode, it is a very useful button.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[fumei]

Yes, I'm sure it would. Hmmm...ahem...."without realizing". That seems to make the issue the person opening the file (and their forgetfulness). If you are possibly going to correct errors, why would you open it in read-only?

I certainly can see making something read-only for someone else looking at it. But if it is YOUR file, do you commonly assume there is no possibility of errors?

I am joshing. I'm sure it is useful and handy.

Gerry
My paintings and sculpture