I have a macro that I want to be able to call from other macros, but it is
important that it cannot be run by users.

I have tried making it Private, but then the other macros also can't call
it.

Is there a way around this?

Thanks

Michelle

Bloomin' marvellous answer - I can't believe I've not come across this
before - Thank you

M

"royUK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> If you place the private module in a separate module and use Option
> Private Module it will not show in the Macro list for that workbook.
>
>
> Code:
> --------------------
> Option Explicit
> Option Private Module
>
> Sub test()
> MsgBox "Hello World"
> End Sub
> --------------------
>
>
> Place the main code in another module
>
>
> Code:
> --------------------
> Option Explicit
>
> Sub main()
> test
> End Sub
> --------------------
>
>
> --
> royUK
>
> Hope that helps, RoyUK
> For tips & examples visit 'my web site' (http://www.excel-it.com/)
> ------------------------------------------------------------------------
> royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
> View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35285
>

You could even ask for a password...

Option Explicit
Sub MichelleOnly()
dim myStr as string

myStr = inputbox(prompt:="What's the password")

if mystr <> "ThisISToPSecRet" then
exit sub
end if

'rest of code
End sub

Michelle wrote:
>
> I have a macro that I want to be able to call from other macros, but it is
> important that it cannot be run by users.
>
> I have tried making it Private, but then the other macros also can't call
> it.
>
> Is there a way around this?
>
> Thanks
>
> Michelle

--

Dave Peterson