After you've made a backup copy, open your Excel 2003 workbook containing your macros in Excel 2010. For the most part, nothing has changed in the macro department, meaning Excel 2010 is able to recognize and run Excel 2003 macros. The biggest difference is setting security settings to allow macros to run.
For macros stored in individual Excel 2003 workbooks, follow this method. Skip to the Personal Workbook Macros section below for converting universal macros. If you're lucky, your macros will run with no problem. Try running your macros as usual. If you have no problems, select File and Save As and choose Excel Workbook to save your workbook in the Excel 2010 format.
If you receive an error message or the macro doesn't run at all, you must change your security settings. Go to File and select Options. Select Trust Center. Press the Trust Center Settings button. Choose Macro Settings. Select either Disable all macros with notification or Enable all macros. This will allow all macros to run, no matter what or you'll be able to choose whether to disable macros or not when a new workbook is opened.
Another option is to store your workbook in a trusted location. By default, typical workbook locations are not trusted. Select Trusted Locations and press Add new location. Browse to the location the workbook is stored, such as My Documents to add the folder as a trusted location.
In the worst case scenario, copy the code from your Notepad backup and copy it directly into the Visual Basic editor in Excel 2010 to create your new macros. Select the Developer tab and choose Visual Basic to open the editor.