Not allowing users to run macros from Tools-Macros

[gautammalkani]

Hi All

I have locked off my macros if the user goes to VB editor.

Is there a way to prevent the user from seeing the macro names when they go to Tools -> Macros?

Thanks for your help

Gautam

 

[fredericofonseca]

change your functions definition from public to private.

This may affect your other code so change accordingliy

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[vbap]

I believe only public subroutines show up as macros. You can convert your subroutines to functions and they won't show or you can do what Frederico says: Change your subroutines from public to private. Private subroutines do not show either. However if you have subroutines in one module that call subroutines in other modules, private won't do it for you (Scope). You'd have to place them all in one module. Try the Function approach. A function doesn't have to return anything. Also, memory fails me, but I believe you may have to change the syntax a little to call a function as oppose to calling a subroutine.


'This works and you can check out the macros list.
Sub main()
Call tst
Call tst2
Call tst3
End Sub

'by default function is public
Function tst()
x = 1
End Function

'by default subroutine is public
Sub tst2()
y = 2
End Sub

'a private subroutine
Private Sub tst3()
z=3
End Sub

 

[rmikesmith]

Gautam,

See my first reply in thread707-651944 (about 2/3 of the way down the rather lengthy thread).


Regards,
Mike