Doug Boufford wrote:
Dick Kusleika wrote:
Doug

Win98SE and WinXP store the XLSTART folder in different places, post
Excel97, I believe. It sounds like you have two Personal.xls files
on your hard drive.

The laptop is running XP Pro - (fresh install)

There are 2 locations for XLSTART:

C:\Documents and Settings\Douglas A. Boufford\Application
Data\Microsoft\Excel\XLSTART - with NOTHING IN IT
AND
E:\Microsoft Office\Office\XLStart - with BOOK.XLT and PERSONAL.XLS
in it.
I ran Excel & recorded a macro, saved it to Personal.xls, and it went
to the file in E:\Microsoft Office\Office\XLStart.

I liked your logic and thought we had an answer, but.............

Dang. How are you running your macros? Commandbutton? Toolbar button?
Other? See if you can find where its pointing. For instance, if you're
using a toolbar button, check

?Application.Commandbars("Standard").Controls(10). OnAction

in the Immediate Window. Be sure to change the names and numbers to fit
your siutation. For a command button,

?Sheet1.Shapes("MyButton").OnAction

See if those point to the same Personal.xls as the one where your recorded
macro ended up.

Also, did you happen to search for Personal.xls on your drive or just
xlstart? You could have a Personal.xls in a non-xlstart folder that could
be causing the problem.


--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com