VBA code does not work on Mac Excel 2010

Hi there,
I would be very glad if someone of you could help me with code below. I wrote it on MS Excel 2010 and works fine. Now I would like to run on Mac version, but no chance. The code is interupted in first .clearcontents command, if I mark it as comment, it is interupted on next row. I have lastest version of Mac Excel 2011. I put here all code because if I try single command .clearcontents on Mac everything works fine. Hope somebody already faced same trouble and can help me

Please Login or Register  to view this content.

Hi Richard,

I have tried it in test Sub() and as one-row-code it works right. Here you can find part of workbook. If I click Confirm button everything is ok even dynamically added elements (like textbox). The problem appears if I run Prepare button as I described above. Just to remind on Windows Excel version works fine. Thank you in advance for any tips or ideas.

cheers,

Tomas

Of course, sorry for password:-)

Hi,
I tried to track the code and after first .clearcontents command macro will finish, no error, no message, just finished. Any idea? All sheets exist. Could be something in VBA settings, add-ins?

Please Login or Register  to view this content.

Hi,

nobody knows? :-(