How to stop a new macro being recorded

  • Hi All,

    I'm trying to protect a worksheet/book, aside of the usual password protections it seems ok apart from you can record a new marco thereby defeating some of the sercurity.

    Is there a way of stopping this with either the controls or vba?

  • Re: How to stop a new macro being recorded

    If you password protect the VBA project, the recorder won't work.

    Note: The VBA project can't be blank, or it won't take protection. Insert a module and type out any subroutine...

    Sub test
    MsgBox "Hi"
    End Sub

    or whatever, then it will allow protection.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!