Re: How do I make all VBA routines offlimits until a user enters the correct password

From: Bob Phillips (phillips_at_tiscali.co.uk)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 18:15:18 -0000

It would all depend upon how the routines are accessed.
If by menu, don't build the menu.
If from the macro list, maybe use a global variable that is checked in each
routine and if not set exits immediately.
Or maybe some other way, depending on the answer to my question.

But be aware that none of this is foolproof as Excel security is not very
resilient. 

-- 
 HTH
Bob Phillips
"Kevin H. Stecyk" <nospam@no123spam.com> wrote in message
news:ObMLHWXAFHA.3504@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I want to put VBA routines into a workbook.  But I want these routines
> off-limits until a qualified user provides the correct password.  Is there
> an easy to accomplish this?
>
> Thank you.
>
> Regards,
> Kevin
>
>