PDA

View Full Version : Solved: Problems with running pre-Excel 2007 macros



Saquiwej
04-08-2010, 09:29 AM
Gentlemen,
Does anybody know a solution for the following problem?
I have a couple of macros written in Excel 2003, that won’t run in Excel 2007. I am still using the 2003 version, for it fully satisfies all my needs, but I wanted to share my programs with others, some of whom might use the latest version. So, I have sent the files to a friend to test them on v 2007. As a result, we have discovered that the cause of the problem is, that v2007 does not use toolbars, or at least the feature is so radically changed that any code manipulating with toolbars will inevitably fail. Is there any simple way to alter my code in such a way that it might function in all versions of Excel, 2007 included? Any suggestion appreciated.

Bob Phillips
04-08-2010, 10:45 AM
Take a look in the Addins tab, your toolbars should be there.