Hello,

Can someone help me with the following: I have a workbook containing
various macro's which are needed for walking through this workbook. As
this sheet is to be send out to a third party I would like to protect
the whole workbook (all sheet) allong with the underlying
macro's...without stoping the macro's to run when a person wants to
navigate through the sheets.

Is there a statement available which I can incorporate in the existing
macro?

Thanks a lot for your assistance!!!

Rgds,
Robert

Hi Robert,

it is a very complex task. First of all note, that you cannot really
protect Excel files - if someone will want to bypass your protection,
with appropriate knowledge he is able to do it (quite easily).

What about your macros? User can disable macros while opening the
workbook. So you have to force him somehow to allow macros... Someone
may try to use password breaker, how you handle this?

Basically, what you can do is to protect your code, you can protect all
worksheets and whole workbook, you can hide all sheets and let visible
only one saying to the user that he should enable macros (that will
unhide the needed sheets). You need to solve what happens while saving,
saving as, printing and closing the workbook.

Regards,
Ivan