Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 119
Default Project Protection

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
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




  #3   Report Post  
Posted to microsoft.public.excel.programming
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Project One - Nearly done - Protection issues Dean Goodmen[_2_] Excel Programming 2 November 22nd 04 09:23 PM
Writing dynamic code - problem with VBA project protection pauly Excel Programming 1 November 11th 04 02:34 PM
Assigning the Help 4, *.HLP file for a project programmatically in a protected Project Tony Seiscons Excel Programming 0 October 4th 04 03:10 PM
VB project protection Frank C. Excel Programming 2 January 12th 04 03:29 PM
Discussion: VBA Project Code Protection Edwin Tam (MS MVP) Excel Programming 2 November 14th 03 02:24 PM


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"