LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
XP XP is offline
external usenet poster
 
Posts: 389
Default Back door into locked form

Hi,

Yes, the workbook method you suggested is superb. I am already using it!
Thanks to that, I can now keep users from opening a form directly, instead
they must use a specific loading program that keeps macros running, etc.

Thanks...

"Peter T" wrote:

Why not go through the front door, supply correct password and unlock the
project.

If you don't want to view code and merely want some other menu or controls
made visible, eg

- check a certain cell for password
- click in a particular region of the form or some control, trap mouse X/Y
while say holding alt-shift
- password in a textbox
- combination of the above
- loads of ways !

In passing, in your other recent post did the very hidden wb suggestion work
for your purposes.

Regards,
Peter T

"XP" wrote in message
...
Using Office 2003 and Windows XP;

I am developing a form for wide distribution that will be locked down

fairly
well. I know anything can be hacked, the sole purpose is to discourage

casual
mistakes and tampering that would generally compromise the programming

built
into the form.

However, I need to build myself a back door into the form that will unlock
everything and restore certain menus that will be controlled, etc. This is
needed so that myself and another developer can periodically perform
maintenance on the form. I already have the unlocking code written, but

what
is a good way to access it without a user stumbling onto the key?

Does anyone have any suggestions for how to "back door" my way into my own
locked down form once its placed into production?

All suggestions welcomed, please respond...thanks in advance.




 
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
Lockout Services Los Angeles Locked Out Open Door Locksmith1-323-678-2704 emil cohen Excel Worksheet Functions 0 September 1st 09 07:35 PM
how do I create a locked form to fill in the blanks bill Excel Discussion (Misc queries) 1 November 2nd 08 05:06 AM
File in 2007 form - need to get back to 2003 form... RHM Excel Discussion (Misc queries) 2 May 7th 07 05:38 AM
Locked form: {End} key with arrows doesn't work as normal quartz[_2_] Excel Programming 1 July 11th 05 06:13 PM
Back Door to VBA? Wayne[_5_] Excel Programming 3 February 10th 04 01:45 AM


All times are GMT +1. The time now is 02:56 AM.

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

About Us

"It's about Microsoft Excel"