Apply Macro to all Worksheets in the file

[dbthj]

There are multiple worksheets in one Excel file. They all have the same type of data with the same format. Multiple users reference this, many of whom have even less knowledge of Excel than I do. I want all of the worksheets to be formatted the same. I know a couple of ways to get a macro to execute on opening and they operate on whichever sheet last had saved changes. I need the same macro to automagically be applied to ALL of the worksheets. The most I want a user to have to do is enable macros when opening the file. Can that easily be done? While I have some vbscript skills, I am unfamiliar with Excel-specific methods. I just want to record a macro and get it to work on all the sheets.

[dbthj]

I should mention that I use mostly Excel 2003