CODEWITHSUNDEEP
vbaexcel
lolatu2
lolatu2

Reputation: 383

Can I write a macro to block other macros?

I'm working with an Excel document that I'm trying to add protection to. Unfortunately, there are very simple macros that can be run to remove the standard password protection. Is there a way I can add a macro to the workbook that blocks other macros from running? Like, on event that another macro runs, give a msg and exit the other macro?

Upvotes: 0

Views: 218

Answers (1)

Johnny Bones
Johnny Bones

Reputation: 8402

The simple answer is, No.

The expanded, convoluted answer is, theorhetically you could fire code at regular intervals that will intercept any current process. But, it will slow your worksheet down because you'd have to fire it off every few seconds for it to be effective, and you would have to determine somehow whether the process intercepted was "authorized". That's a lot of scripting and a lot of logic dedicated to the off-chance that one of your users has malicious intent.

Upvotes: 1

Related Questions