Disable running macro from Developer tap

[Undo]

Hello

I have macro to unprotect all sheet, so users can easily open macros from developer tap and run this macro to unprotect the sheets
is there anyway to avoid this?

[Andy Pope]

If you just want to remove the routine from the dialog make it private

Please Login or Register  to view this content.

You can still run the code from the dialog, but you need to know the name of the routine

I assume you vb project is locked so they can not see the code?

Edit: You can disable the button using ribbon xml, if you really want to.

[Undo]

Yes project is locked
But I am calling the sub from every where in the VBA code
sheets,userforms, modules

making it private will make problems?

[TMS]

You could maybe add an Optional parameter that you don't use in the routine.