I have built a workbook BookA in Excel97 with a number of sheets an
associated macros. BookA is backed up to another one (by copy/past
values from the main 'Current' sheet to the BookA Backup 'Current
sheet. These sheets have worksheet formatting - hence the need fo
paste values. This method has worked fine for over a year.

When I make enhancements to BookA or its associated macros, and wan
to copy these changes to BookA Backup I open BookA and then saved as..
BookA Backup (removing the password), overwriting the earlier versio
of the backup.

When I reopen BookA, the macro buttons on the toolbars have re-assigne
themseves to the backup so I just re-assign them back to BookA.

However, I now find that when I try to re-assign them, BookA crashe
with an application error - access violation (0xc0000005), Address
0x3003e74e (although I think these addresses change).

I can, instead, make a copy of BookA and rename it (and remove th
password) which seems to work, but I am concerned about it crashin
during this reassigning of the buttons. So far it has not crashed i
use, but I am concerned that that BookA will not now be stable.

Any ideas why this might be occurring or suggestions for solving it?

Pau

--
Message posted from http://www.ExcelForum.com