Show if file is opened in read only

[test]

Hello,

Is it possible to show in an xls file a warning that the file is
opened as read only?

I've got this xls file that can be consulted by everyone, but changed
only by people that have the password.
If somebody opens the file as read only and tries to edit a cell,
maybe a warning that the changes will not be saved could appear?
Or a cell that show a text that the file is read only would do nicely
too.

Is this possible in XLS?

Thank you

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[GS]

Hello,

Is it possible to show in an xls file a warning that the file is
opened as read only?

I've got this xls file that can be consulted by everyone, but changed
only by people that have the password.
If somebody opens the file as read only and tries to edit a cell,
maybe a warning that the changes will not be saved could appear?
Or a cell that show a text that the file is read only would do nicely
too.

Is this possible in XLS?

Thank you

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

Are you saying the window caption does not display (Read Only) after
the filename?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[test]

Are you saying the window caption does not display (Read Only) after
the filename?

No I want a message (of some kind) that the file is opened as read
only.
This to make sure that users don't think they are editing the file,
but the changes will not be saved because the file is read only.

So a message IN the spreadsheet (a text in a cell for example, or a
pop up window) would do the trick.

Thanks for your response.

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[GS]

There's a couple ways to go...

1. You could apply sheet protection so the editing password is required
to make changes. This renders your file 'read only' regardless of how
opened. This would be my preferred suggestion because it's the easiest
to impliment/maintain.

2. This requires VBA.
Given that a password is already required to edit the file, I assume
this applies to the file being opened and so suggest you scrap this
approach if in place currently. As an alternative, you can have VBA
require users to 'log in' when the file opens so your password can be
used to remove sheet protection for authorized users.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[GS]

I forgot to mention that Excel will display a notification when users
attempt to edit locked cells on protected sheets.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[test]

No I want a message (of some kind) that the file is opened as read
only.
This to make sure that users don't think they are editing the file,
but the changes will not be saved because the file is read only.

So a message IN the spreadsheet (a text in a cell for example, or a
pop up window) would do the trick.

Thanks for your response.

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

Thank you GS, but I want something the users can see in the
spreadsheet that the file is opened read only.
I guess this must be done with VBA, I don't know.

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[GS]

Thank you GS, but I want something the users can see in the

spreadsheet that the file is opened read only.

So then just enter the desired text in a cell!

Excel offers built-in methods to prevent unauthorized editing. My
suggested method #1 is the easiest and most common method. If you want
to impliment some convoluted, non-standard method via VBA then you'll
have to be very explicit about how you want it to work. Please provide
these details...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion