Can I prevent a user from running a macro?

[Michelle]

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

 

[Michelle]

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

M

 

[Dave Peterson]

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