remove makros from a protected VBProject?

    Hi,


    I have an Excel workbook, where when the user want to update, then my VBProject shall copy a sheet over to another workbook (Old Sheets). In this workbook I don't want the sheets makros to be played. :)
    So I tried to remove the makros from the sheets in the programme, but I get the error, that my VBProject is protected :(
    How can I unprotect my VBProject in a makro?


    Thanks


    Woody93

    I don't think there is a method to programatically unprotect a VBA project as if there was the security would be a bit pointless wouldn't it?


    For some general protection FAQ check out http://j-walk.com/ss/excel/faqs/protectionFAQ.htm


    HTH

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

Participate now!

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

Register Yourself Login