Read Only Message for open workbook

L

Les

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.
 
P

pswanie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top