View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bart Snel
 
Posts: n/a
Default Read only indicator

nathan schreef:
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 "read-only" mode? The idea is to prevent someone
from forgetting that the file is "read-only", making a bunch of changes to
it, only to later realize that their work can't be saved (without doing a
"save as" a different file name). i.e. a message window that appears when
typing?? watermark?? etc etc??

Thanks.

I's suggest to protect the worksheet. In that case users cannot edit
without unprotecting.

Bart Snel