Project Protection

[Don Lloyd]

Hi all,

I'm looking for advice on the following scenario.

Single workbook project.
No Menus / Toolbars - all done from controls on the worksheets.
All sheets protected - userinterfaceonly - no passwords.
Code is password protected and not in view.

Would there be any further benefit from password protecting the Workbook and
the Worksheets.

Any advice or comments welcome.

Regards,
Don

 

[Tom Ogilvy]

Would there be any further benefit from password protecting the Workbook
and

the Worksheets.

You already said all sheets are protected, so not sure how you would further
protect them.

Protecting the workbook disallows creating/deleting/renaming sheets or
changing window layouts. Protecting the workbook does appear to encrypt the
file. In any event, all these password protections can be easily broken -
most with code posted here on a weekly basis.

So you make the call.

 

[Don Lloyd]

Thank you Tom,

I was just weighing up the 'deterrent' factor.

Don