hw we call a private macro in other sheet from module1

Hello

We r working in a workbook with few macros which is in PRIVATE sub ….all macros in Module1

We are using a VBA in Sheet1 where we want to call A macro for example Macro1
But show a error when we remove PRIVATE macro run..

But we don’t want to remove PRIVATE so pls guide me how can I call a private macro in other sheet from module1

Thanks in advance
<Santosh>

Sounds like your goal may be to hide macros from the macros dialog. If so, see: http://www.mrexcel.com/archive/VBA/12141.html

hello Kenneth hobson
We got help from ur provided link.. & my problem solve but in that module which was public macro that was not working

actually we make a custom menu in excel with public macro where we hide some commonbar hide & when we goes other workbook then unhide those commondbar which was hide in previous worksheet... so this show a error..

is there any option where both work private & public..

The link explained how to do it. Public makes it available to the end user via the macros dialog. I doubt you would want that.

As suggested by Izondol, Application.Run might be sufficient for your needs.
e.g.
In Sheet1:

Please Login or Register  to view this content.

In a Module or other:

Please Login or Register  to view this content.