View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Project Protection

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