I don't know if it's the same issue but I lost macros too when I had the
Excel file open in Excel and in the Office Custom UI editor at the same
time. My regimen now is to have it open in only one at a time.
--
Jim
"SteveDB1" wrote in message
...
| Hi all.
| This is a really strange thing that no one else has experienced in my
office.
|
| I'll copy my macros from one macro module in VBA to another macro module.
| I'll then save, ctrl+s, etc... the file.
| I'll then close the excel file to continue working on my xlam menu file,
| save that, validate, and then generate the callbacks.
| All will come up well, etc.... Then, I'll go back into Excel to review,
and
| test the menu, and find that a specific group of macros are not working. I
| then go back into VBA, and find that one specific group of macros that I'd
| previously saved-- 15 or 20 times now-- are not there.
| I then go to the xlsb file that I'd originally pulled those macros from,
and
| copy/paste thenm in to the xlam file all over again.
| And of course, the process starts all over again.
| Fortunately, my xlam menu is now complete, and I'd like to get down to
| business.
| So, does anyone have any idea as to why this could be happening?
| It's getting really old.
| As always, thank you in advance.
| Have a great day.
|