|My major issues is hiding all of the most important commands like Format Cells, Move/Copy Worksheet, Recording Macros.|
I went from 2000 to 2007 and there is a learning curve,
but I did not find it that difficult.
It seems daunting at first, but, as with most things, you adjust.
I can't comment on your Macros, but all of my worksheets worked the first time,
after the upgrade.
It takes a long time in Office 2000 and an Internet search to find basic commands
Here's a file I keep around, you might find handy:
I've been using it since version 2.