Macro protection error 2003

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hello to all,

    I have developed a survey sheet using 2007 and saved a copy for use with 2003. When end users try to utilize the protected sheet in 2003 they get a runtime error whenever they click the button linked to this macro. This also occured with 2010 version. I was able to load the version created with the 2007 onto a machine I have with 2010 on it and eliminated the error by unprotecting the sheet, re-protecting it making sure the Edit Objects box was checked. I tried this with 2003 on a machine running 2003 but I still receive the same error. I went as far as to check every box in the protection screen to no avail.

    The error goes away if you unprotect the sheet. Both the 2007 and 2010 versions work perfectly now. Can anybody help to determine if I'm simply unable to run this macro within a protected 2003 version?

    The code is to insert a picture

    Thanks in advance

  • Re: Macro protection error 2003

    Helloo Excel Noob

    How about putting this between Exit Sub and Set pic


    And this before End Sub

  • Re: Macro protection error 2003



    I saw an example of that in a related thread where it would also add the password back into it as well. I'll go that way if I have to but I probably have 40 versions of this code in this workbook that I would have to go back and alter. I'd like to avoid that if there's any way possible.

Participate now!

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