View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pswanie pswanie is offline
external usenet poster
 
Posts: 247
Default 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