software

Does anyone have any suggestions on how to create some sort of obvious
indicator/reminder (other than on the Excel window header) that states that a
workbook is currently in quot;read-onlyquot; mode? The idea is to prevent someone
from forgetting that the file is quot;read-onlyquot;, making a bunch of changes to
it, only to later realize that their work can't be saved (without doing a
quot;save asquot; a different file name). i.e. a message window that appears when
typing?? watermark?? etc etc??

Thanks.

nathan schreef:
gt; Does anyone have any suggestions on how to create some sort of obvious
gt; indicator/reminder (other than on the Excel window header) that states that a
gt; workbook is currently in quot;read-onlyquot; mode? The idea is to prevent someone
gt; from forgetting that the file is quot;read-onlyquot;, making a bunch of changes to
gt; it, only to later realize that their work can't be saved (without doing a
gt; quot;save asquot; a different file name). i.e. a message window that appears when
gt; typing?? watermark?? etc etc??
gt;
gt; Thanks.
I's suggest to protect the worksheet. In that case users cannot edit
without unprotecting.

Bart Snel

It's a long story but quot;protectionquot; can't be used.

quot;Bart Snelquot; wrote:

gt; nathan schreef:
gt; gt; Does anyone have any suggestions on how to create some sort of obvious
gt; gt; indicator/reminder (other than on the Excel window header) that states that a
gt; gt; workbook is currently in quot;read-onlyquot; mode? The idea is to prevent someone
gt; gt; from forgetting that the file is quot;read-onlyquot;, making a bunch of changes to
gt; gt; it, only to later realize that their work can't be saved (without doing a
gt; gt; quot;save asquot; a different file name). i.e. a message window that appears when
gt; gt; typing?? watermark?? etc etc??
gt; gt;
gt; gt; Thanks.
gt; I's suggest to protect the worksheet. In that case users cannot edit
gt; without unprotecting.
gt;
gt; Bart Snel
gt;

Try this:
Select the range from A1 thru the last cell most likely to be changed.

Datagt;Validation
Allow: Custom
Formula: =ISBLANK(A1)

Select the Error Alert tab
Style: Warning
Title: REMINDER
Error Message: This workbook is read only
Click [OK]

That way....every time they try to change a cell, they are warned that the
wkbk is read-only.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;nathanquot; wrote:

gt; It's a long story but quot;protectionquot; can't be used.
gt;
gt; quot;Bart Snelquot; wrote:
gt;
gt; gt; nathan schreef:
gt; gt; gt; Does anyone have any suggestions on how to create some sort of obvious
gt; gt; gt; indicator/reminder (other than on the Excel window header) that states that a
gt; gt; gt; workbook is currently in quot;read-onlyquot; mode? The idea is to prevent someone
gt; gt; gt; from forgetting that the file is quot;read-onlyquot;, making a bunch of changes to
gt; gt; gt; it, only to later realize that their work can't be saved (without doing a
gt; gt; gt; quot;save asquot; a different file name). i.e. a message window that appears when
gt; gt; gt; typing?? watermark?? etc etc??
gt; gt; gt;
gt; gt; gt; Thanks.
gt; gt; I's suggest to protect the worksheet. In that case users cannot edit
gt; gt; without unprotecting.
gt; gt;
gt; gt; Bart Snel
gt; gt;

Thanks, that is a great idea and almost works. It is less than ideal because
this warning will appear regardless of the read-only/read-write status of the
file. There are constant changes being made to the file by multiple people
so this warning would come up all the time even in read-write and be
cumbersome. (for various reasons we can't use sharing, so people are always
switching in and out of read-only, and only one person at a time is
read-write. so, you can see how easy it is for someone to forget they are in
read-only and make changes).

quot;Ron Coderrequot; wrote:

gt; Try this:
gt; Select the range from A1 thru the last cell most likely to be changed.
gt;
gt; Datagt;Validation
gt; Allow: Custom
gt; Formula: =ISBLANK(A1)
gt;
gt; Select the Error Alert tab
gt; Style: Warning
gt; Title: REMINDER
gt; Error Message: This workbook is read only
gt; Click [OK]
gt;
gt; That way....every time they try to change a cell, they are warned that the
gt; wkbk is read-only.
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;nathanquot; wrote:
gt;
gt; gt; It's a long story but quot;protectionquot; can't be used.
gt; gt;
gt; gt; quot;Bart Snelquot; wrote:
gt; gt;
gt; gt; gt; nathan schreef:
gt; gt; gt; gt; Does anyone have any suggestions on how to create some sort of obvious
gt; gt; gt; gt; indicator/reminder (other than on the Excel window header) that states that a
gt; gt; gt; gt; workbook is currently in quot;read-onlyquot; mode? The idea is to prevent someone
gt; gt; gt; gt; from forgetting that the file is quot;read-onlyquot;, making a bunch of changes to
gt; gt; gt; gt; it, only to later realize that their work can't be saved (without doing a
gt; gt; gt; gt; quot;save asquot; a different file name). i.e. a message window that appears when
gt; gt; gt; gt; typing?? watermark?? etc etc??
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks.
gt; gt; gt; I's suggest to protect the worksheet. In that case users cannot edit
gt; gt; gt; without unprotecting.
gt; gt; gt;
gt; gt; gt; Bart Snel
gt; gt; gt;