Read Only Message for open workbook
Not realy sure how workbook thats protected will react etc.. (not using any
protected workbooks. only protect sheets)
Maybe u can put a userform in and a text on that? with a command button and
"behind" that a userform1.hide..
and then a userform1.show in the worksheet_change event.
or even in the workbook_open. that way the userform will come up when the
book is opend.
"Les" wrote:
Hello all, i have a workbook that is protected and therefore do not want to
share. What i want to know is, is it possible in addition or to replace the
standard message of " this workbook is locked for editing, open as read only
" ??
I would like to give a more comprehensive message to the other person.
--
Les
|