Thread: Macro Protection

Hi again,

i have a simple macro that clears unlocked cell contents on a worksheet. However, as the worksheet is used by several people its possible one of them may run the macro...unlikely but i'd rather they didn't have the choice. Is it possible to password protect the macro or something similar?


Thanks.

Hi Fodman,

If you preface your macro with the word Private, the macro will not show up
in the list of macros, e.g.:

Private Sub MyMacro

'Your code

End sub

Alternatvely, try something like:

'=============>>
Public Sub MyMacro()
Dim res As String

res = InputBox("Insert the password")

If res <> "YourPassword" Then
Exit Sub
End If

'Your code

End Sub
'<<=============


---
Regards,
Norman


"fodman" <fodman.29xavc_1151180404.7767@excelforum-nospam.com> wrote in
message news:fodman.29xavc_1151180404.7767@excelforum-nospam.com...
>
> Hi again,
>
> i have a simple macro that clears unlocked cell contents on a
> worksheet. However, as the worksheet is used by several people its
> possible one of them may run the macro...unlikely but i'd rather they
> didn't have the choice. Is it possible to password protect the macro or
> something similar?
>
>
> Thanks.
>
>
> --
> fodman
> ------------------------------------------------------------------------
> fodman's Profile:
> http://www.excelforum.com/member.php...o&userid=31941
> View this thread: http://www.excelforum.com/showthread...hreadid=555276
>

Am i missing something?....How then do i find the macro if it doessn't show up in the macro list?

Hi Fodman,

Even though the macro will not show up in the macro dialog, you can run the
macro by typing the macro's name.

However, why not try my suggested password suggestion?


---
Regards,
Norman


"fodman" <fodman.29xc9b_1151182203.497@excelforum-nospam.com> wrote in
message news:fodman.29xc9b_1151182203.497@excelforum-nospam.com...
>
> Am i missing something?....How then do* i *find the macro if it doessn't
> show up in the macro list?
>
>
>
>
> --
> fodman
> ------------------------------------------------------------------------
> fodman's Profile:
> http://www.excelforum.com/member.php...o&userid=31941
> View this thread: http://www.excelforum.com/showthread...hreadid=555276
>