Macro button works for 2010 users, but not 2013

HI:

Macro button works for 2010 users, but not 2013. In 2013 we are receiving error "Run Time Error 1004" for macros, the debug goes to this line "ActiveWorkbook.Close SaveChanges:=False"

If we run the macros from the developer tab or VBA it works fine.

I have already deleted the .exd file extensions and restarted.


Attached is the code.

Thanks

Hi there,

The attached version of your routine appears to run correctly on my Office 2013 installation.

It uses the following code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg:

Thanks you so much for taking time to try and help me. However; the command "wbkBlankVIT.Close SaveChanges:=False" is still a error. When I run the code from VBA or the Developer tab it works fine, but not using the button. I even created a new button without success.

The code you provided is much better than mine and have learned something new and appreciate that.
Regards
John

Hi again John,

Many thanks for your feedback and for your kind words - glad to have helped, even if only a little.

If you think it would be useful, I can try running your workbooks on my 2013 installation to see if the same thing happens here - just a suggestion.

Best regards,

Greg M