View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Lloyd Don Lloyd is offline
external usenet poster
 
Posts: 119
Default Project Protection

Thank you Tom,

I was just weighing up the 'deterrent' factor.

Don


"Tom Ogilvy" wrote in message
...
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.
--
Regards,
Tom Ogilvy

"Don Lloyd" wrote in message
...
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