Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 2
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 ?

  #2   Report Post  
Posted to microsoft.public.excel.setup
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 ?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Protection over Excel 2000 and 2003 Achez Excel Discussion (Misc queries) 3 June 6th 06 07:50 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
Make Excel 2000 print long narrow list "snake" on wide paper? steve from mw rms rrd Excel Discussion (Misc queries) 2 March 1st 06 07:25 PM
Excel on XP: Password Protection Rich Hayes Excel Discussion (Misc queries) 1 February 4th 05 10:47 PM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"