Hi,

i developed at home on Win 8.1 Office Prof Plus 2010 Excel V.14.0.7128.5000 (32bit) a Worksheet with VBA Macro.

But it doesn't work on my work machine with Win 7 14.0.7140.5002 (32bit). It causes an runtime error 32809 immediately, but not on my Office 2010 and Office 2013 at home ... 

I don't know how to help myself - i googled something about KB2553154 .... but i am not sure and my boss / company won't give me rights on the machine to fix the issue .... isn't that a bad thing of Microsoft to let different versions deprecate ??? 

I mean - what should i do ? it's 100 lines and i don't even know where to start to fix anything ....

Anyone has a clue how i can still run my little VBA Macro worksheet in a mode where no security updates and fixits are involved ?

The error is caused by 

Private Sub Workbook_Open()
Worksheets("Name of Worksheet").Activate
Worksheets("Name of Worksheet").fillC

End Sub

- but let's be honest - it's works at home on 2 different comupters - why not at work ? 

Thanks in advance

• Edited by V3r0x Monday, February 02, 2015 8:10 PM

Hi,

This issue is about the Excel Development, we don't provide suggestions about VBA/Macro in this forum. I suggest you post this question in Excel for Developers forum to get more dedicated assistance:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Regards,

Melon Chen
TechNet Community Support