Code created in Excel 2010 does not work with Excel 2013

**Steve@Rugby** · 01-28-2014, 09:33 AM

Hi All,

I have being trying to help a user on another thread. The attached file has some code I wrote in Excel 2010 which works fine, however it gives him errors when used with Excel 2013.

The code is written to:
1) Populate cells based on selection from a combobox on Sheet1 cell C4. (If sheet is protected this code will also unprotect it, make changes then protect again)
2) Protect/Unprotect (asking for password) Sheet1 using an activex commandbutton on Sheet1 cells E2:F3 (this code also re-names the activex button when it is pressed)

I wondered if anyone could please help diagnose if it is a compatibility (2010-2013) issue or problem with my code? I have no experience with 2013!

Thanks in advance

Regards
Steve

**TMS** · 01-28-2014, 10:10 AM

I don't have 2013 (yet) but I can't see anything that's an obvious candidate.

Check in Tools | References for any missing references. Different versions of Excel may use different libraries ... and the error reported may have nothing to do with the missing library.

The ComboBox1_Change could be:

Please Login or Register  to view this content.

Regards, TMS

**Steve@Rugby** · 01-28-2014, 10:14 AM

Hi TMS,

Thanks for your advice, I can check this myself as I also do not have 2013. I will ask the guy on the other thread to do this with his version.

Regards
Steve