Protect macros?

[[email protected]]

How can I keep a user from accessing macros in a spreadsheet. I have
some of the macros run when needed via VBA, and I have other macros
that I use for such things as protecting or unprotecting all or
selected sheets as needed. But I don't want the other users to be
able to manually access the macros.
Thanks for any help.

[JulieD]

Hi

you can password protect the vba project (ie the macros), press ALT & F11 to
switch to the VBE editor,
find your workbook's name in the Project Explorer (view / project explorer)
right mouse click on it
choose VBAProject Properties
Go to the protection tab
tick the check box and put a password in.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
<[email protected]> wrote in message
news:[email protected]...
> How can I keep a user from accessing macros in a spreadsheet. I have
> some of the macros run when needed via VBA, and I have other macros
> that I use for such things as protecting or unprotecting all or
> selected sheets as needed. But I don't want the other users to be
> able to manually access the macros.
> Thanks for any help.
>

[[email protected]]

Thanks Julie. I had done that, but the user can still run a macro by
selecting Tools/Macro, selecting a macro, and clicking Run.

Also, I realize that worksheet and workbook protection are easily
bypassed. I just need to keep the user from stupidly running a macro
that can screw up the book.


On Thu, 12 May 2005 22:42:59 +0800, "JulieD"
<[email protected]> wrote:

>Hi
>
>you can password protect the vba project (ie the macros), press ALT & F11 to
>switch to the VBE editor,
>find your workbook's name in the Project Explorer (view / project explorer)
>right mouse click on it
>choose VBAProject Properties
>Go to the protection tab
>tick the check box and put a password in.

[Dave Peterson]

If you add:
Option Private Module
to the top of each general module, then the names won't be visible in the
Tools|macro|macros... dialog.

[email protected] wrote:
>
> Thanks Julie. I had done that, but the user can still run a macro by
> selecting Tools/Macro, selecting a macro, and clicking Run.
>
> Also, I realize that worksheet and workbook protection are easily
> bypassed. I just need to keep the user from stupidly running a macro
> that can screw up the book.
>
> On Thu, 12 May 2005 22:42:59 +0800, "JulieD"
> <[email protected]> wrote:
>
> >Hi
> >
> >you can password protect the vba project (ie the macros), press ALT & F11 to
> >switch to the VBE editor,
> >find your workbook's name in the Project Explorer (view / project explorer)
> >right mouse click on it
> >choose VBAProject Properties
> >Go to the protection tab
> >tick the check box and put a password in.

--

Dave Peterson

[[email protected]]

Thanks Dave. That's what I was looking for. I've tinkered with Excel
for a few years, but I just keep on learning new stuff all the times.
Thanks to all who replied.



On Thu, 12 May 2005 18:51:58 -0500, Dave Peterson
<[email protected]> wrote:

>If you add:
>Option Private Module
>to the top of each general module, then the names won't be visible in the
>Tools|macro|macros... dialog.
>
>[email protected] wrote:
>>
>> Thanks Julie. I had done that, but the user can still run a macro by
>> selecting Tools/Macro, selecting a macro, and clicking Run.
>>
>> Also, I realize that worksheet and workbook protection are easily
>> bypassed. I just need to keep the user from stupidly running a macro
>> that can screw up the book.
>>
>> On Thu, 12 May 2005 22:42:59 +0800, "JulieD"
>> <[email protected]> wrote:
>>
>> >Hi
>> >
>> >you can password protect the vba project (ie the macros), press ALT & F11 to
>> >switch to the VBE editor,
>> >find your workbook's name in the Project Explorer (view / project explorer)
>> >right mouse click on it
>> >choose VBAProject Properties
>> >Go to the protection tab
>> >tick the check box and put a password in.

[SharonP.]

Dave, I'm working with this hint and am having a problem/question.
When I add this Option Private Module as a Declaration - is is not visible
in the Tool/Macro/Macros but I also can't run the macro either. What am I
missing. I don't want the macro viewable for the general public but I need
to run it still.

"Dave Peterson" wrote:

> If you add:
> Option Private Module
> to the top of each general module, then the names won't be visible in the
> Tools|macro|macros... dialog.
>
> [email protected] wrote:
> >
> > Thanks Julie. I had done that, but the user can still run a macro by
> > selecting Tools/Macro, selecting a macro, and clicking Run.
> >
> > Also, I realize that worksheet and workbook protection are easily
> > bypassed. I just need to keep the user from stupidly running a macro
> > that can screw up the book.
> >
> > On Thu, 12 May 2005 22:42:59 +0800, "JulieD"
> > <[email protected]> wrote:
> >
> > >Hi
> > >
> > >you can password protect the vba project (ie the macros), press ALT & F11 to
> > >switch to the VBE editor,
> > >find your workbook's name in the Project Explorer (view / project explorer)
> > >right mouse click on it
> > >choose VBAProject Properties
> > >Go to the protection tab
> > >tick the check box and put a password in.
>
> --
>
> Dave Peterson
>

[Ron de Bruin]

Hi Sharon

Press Alt F8 and enter the macro name

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SharonP." <[email protected]> wrote in message news:[email protected]...
> Dave, I'm working with this hint and am having a problem/question.
> When I add this Option Private Module as a Declaration - is is not visible
> in the Tool/Macro/Macros but I also can't run the macro either. What am I
> missing. I don't want the macro viewable for the general public but I need
> to run it still.
>
> "Dave Peterson" wrote:
>
>> If you add:
>> Option Private Module
>> to the top of each general module, then the names won't be visible in the
>> Tools|macro|macros... dialog.
>>
>> [email protected] wrote:
>> >
>> > Thanks Julie. I had done that, but the user can still run a macro by
>> > selecting Tools/Macro, selecting a macro, and clicking Run.
>> >
>> > Also, I realize that worksheet and workbook protection are easily
>> > bypassed. I just need to keep the user from stupidly running a macro
>> > that can screw up the book.
>> >
>> > On Thu, 12 May 2005 22:42:59 +0800, "JulieD"
>> > <[email protected]> wrote:
>> >
>> > >Hi
>> > >
>> > >you can password protect the vba project (ie the macros), press ALT & F11 to
>> > >switch to the VBE editor,
>> > >find your workbook's name in the Project Explorer (view / project explorer)
>> > >right mouse click on it
>> > >choose VBAProject Properties
>> > >Go to the protection tab
>> > >tick the check box and put a password in.
>>
>> --
>>
>> Dave Peterson
>>

[Jason Morin]

Just be aware that Excel's protection is not invincible. There are commercial
password breakers as well as free methods (ie hex editor) available to break
VBA project passwords. A persistent individual with access to the internet
could view your code if they really wanted to.

HTH
Jason
Atlanta, GA

"[email protected]" wrote:

> How can I keep a user from accessing macros in a spreadsheet. I have
> some of the macros run when needed via VBA, and I have other macros
> that I use for such things as protecting or unprotecting all or
> selected sheets as needed. But I don't want the other users to be
> able to manually access the macros.
> Thanks for any help.
>
>

[[email protected]]

Thanks Jason. I myself have some tools here to break the passwords,
and if I can do it, anyone can. I just need to keep the user from
running a macro that may screw up the book.



On Thu, 12 May 2005 08:08:02 -0700, "Jason Morin"
<[email protected]> wrote:

>Just be aware that Excel's protection is not invincible. There are commercial
>password breakers as well as free methods (ie hex editor) available to break
>VBA project passwords. A persistent individual with access to the internet
>could view your code if they really wanted to.
>
>HTH
>Jason
>Atlanta, GA
>
>"[email protected]" wrote:
>
>> How can I keep a user from accessing macros in a spreadsheet. I have
>> some of the macros run when needed via VBA, and I have other macros
>> that I use for such things as protecting or unprotecting all or
>> selected sheets as needed. But I don't want the other users to be
>> able to manually access the macros.
>> Thanks for any help.
>>
>>