Chip/Tom: thanks for your replies. I tried Tom's (simpliest) but tha
did not help. Before I tried uninstalling and reinstalling Excel,
spent some time backtracking to the original problem and also wen
"sideways" to see how many Excel applications would misbehave (use
copies). Every Excel appl I opened had the same problems; many faile
as soon as I hit the enable macro button. Reinstalling Excel fixed th
problem with all appls except the one that started it all. It wa
still messed up and I ended up deleting it and going back to an earlie
version (luckily I had done a backup of that drive yesterday).
believe that the root cause was an attempt to dupliicate Publi
declaration from a base application in an Add-in specificall
constructed to hold a subroutine library used by the base applicatio
and several sister applications (you both replied to my thread abou
global common). When I started testing the base application after
did that, Excel puked and I spent the next 5 hours trying to figure ou
what went wrong. Any idea why that action would create such havoc?

Thank

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