Sample code is attached.
The issue occurs when I'm downloading an XLSM file without saving it to hard disk first. Run the attached application and press the open button (not the save button). When you try to run the macros on Sheet1, you will get an error message that says the file is locked for editing.
If you save the workbook to disk first, then open into excel 2007 (or 2010), the macros work just fine.
Thanks very much! Cindy