PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup how to hide a list of macros in excel 2000 without password protection

Reply

how to hide a list of macros in excel 2000 without password protection

 
Thread Tools Rate Thread
Old 12-07-2006, 08:15 AM   #1
Padam
Guest
 
Posts: n/a
Default how to hide a list of macros in excel 2000 without password protection


Hi,

I would like to hide a list of macros from user in excel 2000 without
password protection functinality.

could you help me out at padam76@gmail.com?

  Reply With Quote
Old 12-07-2006, 09:10 PM   #2
Gord Dibben
Guest
 
Posts: n/a
Default Re: how to hide a list of macros in excel 2000 without password protection

For unsophisticated users maybe this will work.

Make all your macros Private as in

Private Sub macro1()
code
End Sub

They won't show up in Tools>Macro>Macros or with ALT + F8


Gord Dibben MS Excel MVP

On 12 Jul 2006 00:15:21 -0700, "Padam" <padam76@gmail.com> wrote:

>Hi,
>
>I would like to hide a list of macros from user in excel 2000 without
>password protection functinality.
>
>could you help me out at padam76@gmail.com?


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off