Toggle Disable Insert New Work Sheet

You could put a checkbox in a sheet and change your code to this;

Please Login or Register  to view this content.

It is definitely safer to use workbook protection. It does require a bit more code work though. Example, in the attachment, with three basic macros to handle. If you manually unprotect the file, the BeforeSave event will remember to protect it when saving the file.

Artik

It's always a good discussion when talking about Excel 'security'.

Just wondering why you think a macro with a hard coded password is "definitely safer" than the macro the OP put up?

One of the reasons is that the user has refused to allow macros to run when the file is opened.
It has long been known that "security" in Excel is a delusion.


Artik

Of course it is, that is why I was surprised you mentioned it was 'definitely safer'.

By the way, you can stop the user disabling macros (well, make it harder at least).

Leaving aside the issue of securing the VBA code, I think a better solution is to protect the workbook. When macros are disabled, at least the structure of the workbook will still be protected. And that's what I meant by "definitely safer".

Artik