Excel - Tools - Macro - Macro not Visible

[MJPPaba]

Hi,

I have a module that has been created by a user no longer with us, thank God.

A user has a menu item that executes a procedure. The menu item works fine. The Procuedure is located in the users personal.xls workbook.

Now, if I go to tools..macro...Macro's then I retrieve alist of the mprocedures available. problem is, the procedure that is being executed by the menu item is not listed?

I then go into the VB Editor look through the project explorer for the module and discover that there is a module that is not listed in the tools...macro...macros dialog box and it contains many procedures.

The user that created these was fanatical about digital signatures to athe point of overkill. Fool.

Question is, how can I get these procedures to become visible to the diablog box again.

cheers

Matt

 

[ETID]

Will a Ctrl+break during execution stop the code and let you get in via the debug?

 

[KenWright]

Do the subs by any chance have 'Private' in front of them, eg

Private Sub xyz()
....
....
....
End Sub

If so then you will not see these in the Tools Macro dialog box. If you want to see them then just remove the 'Private' bit.

Usually set up like this because there is no need for anything but the calling routine to ever invoke these routines, so therefore no point in cluttering the dialog box, and also usually safer.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[MJPPaba]

Hi Ken,

Thanks for that, it was my privates that were the root of the problem.

Thanks ETID anyhow.

I always understood the public and private related to the lifetime and scope of the variables. Now I know.

Cheers

Matt

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------