I would like to do a couple of things to hide / protect information in my
excel file (2k3).

1. How can I password protect my VBA so others cannot see or edit it?
2. I Have a worksheet with a command button that starts a macro but I want
to password protect the sheet. I have unlocked the cells that get the update,
but when I run the macro with protection on it says "You cannto use a macro
on a protected sheet". How can I get around this?

Bruce

1. Launch VBE using Alt+F11. Check Tools> VBA Project Properties> Protection>
Check Lock and assign password

2. I am not sure I understood your question...Using code you can unprotect
the sheet and then before End Sub you can protect the sheet again...Does that
help???

If this post helps click Yes
---------------
Jacob Skaria


"Bruce" wrote:

> I would like to do a couple of things to hide / protect information in my
> excel file (2k3).
>
> 1. How can I password protect my VBA so others cannot see or edit it?
> 2. I Have a worksheet with a command button that starts a macro but I want
> to password protect the sheet. I have unlocked the cells that get the update,
> but when I run the macro with protection on it says "You cannto use a macro
> on a protected sheet". How can I get around this?
>
> Bruce

Thanks Jacob, have 1. working now and understand your point on 2. and will
work on it.

Bruice



"Jacob Skaria" wrote:

> 1. Launch VBE using Alt+F11. Check Tools> VBA Project Properties> Protection>
> Check Lock and assign password
>
> 2. I am not sure I understood your question...Using code you can unprotect
> the sheet and then before End Sub you can protect the sheet again...Does that
> help???
>
> If this post helps click Yes
> ---------------
> Jacob Skaria
>
>
> "Bruce" wrote:
>
> > I would like to do a couple of things to hide / protect information in my
> > excel file (2k3).
> >
> > 1. How can I password protect my VBA so others cannot see or edit it?
> > 2. I Have a worksheet with a command button that starts a macro but I want
> > to password protect the sheet. I have unlocked the cells that get the update,
> > but when I run the macro with protection on it says "You cannto use a macro
> > on a protected sheet". How can I get around this?
> >
> > Bruce