Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Writing VBA in Excel 2007 for use in Excel 2003

Tags:

People also ask

Can VBA be used in Excel 2007?

You can access the VBA environment in Excel 2007 by opening the Microsoft Visual Basic window. First, be sure that the Developer tab is visible in the toolbar in Excel. The Developer tab is the toolbar that has the buttons to open the VBA editor and create Form/ActiveX Controls like buttons, checkboxes, etc.

How Excel 2007 is different from previous versions of Excel?

In addition to these features, Excel 2007 includes enhanced conditional formatting that applies visual formatting to data, new functionality in tables, new charting tools, updated PivotTables that are easier to use, three additional file formats, and more.


Where I'm at the developers have been updated to Excel 2007, but most of the users haven't. I'm building a spreadsheet template (*.xlt) for a user that's gonna need some vba code included, and I'm wondering what issues I'm likely to run into building this in 2007 instead of 2003? I don't have access to a machine with Excel 2003 for testing, and I'm worried this particular project is headed for disaster.