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...


    Code
    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!

Register Yourself Login