When that error comes up, click the [Debug] button. That will open the VB
Editor and highlight the line of code where the problem is taking place.

You could then post a copy of the code and tell us which line is the one
that got highlighted. Then people may be able to help you further.


"Anthony" wrote:

I have a .XLS document that runs macros correctly on my laptop with MS
Office 2007 but when I open it on my desktop with MS Office 2003,
gives me the following message: runtime error '438': object does not
support this property or method. I have enabled macros when I open
the workbook on the desktop. Any ideas how I can get the workbook's
macros to work correctly? By the way, the macro is assigned to a
button to create a new worksheet. If I click OK, the sheet is created
but all the data is not. Thanks.
.