Excel VBA - Excel crashes when macro button re-assigned problem

From: PaulC (PaulC.14jzch_at_excelforum-nospam.com)
Date: 04/11/04 

Date: Sun, 11 Apr 2004 09:44:43 -0500

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

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

When I reopen BookA, the macro buttons on the toolbars have re-assigned
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 crashes
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 the
password) which seems to work, but I am concerned about it crashing
during this reassigning of the buttons. So far it has not crashed in
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?

Paul 

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