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