View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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 ToolsMacroMacros or with ALT + F8


Gord Dibben MS Excel MVP

On 12 Jul 2006 00:15:21 -0700, "Padam" 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 ?