ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   how to hide a list of macros in excel 2000 without password protection (https://www.excelbanter.com/setting-up-configuration-excel/98815-how-hide-list-macros-excel-2000-without-password-protection.html)

Padam

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 ?


Gord Dibben

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 ?




All times are GMT +1. The time now is 01:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com