Add-in damaged Excel

M

mliungman

Hi!

I just saved a signature creating macro on our server as an add-in.
This way I can install the add-in on all our workstations and by that
give everyone easy access to the macro. All worked well at first.
However, after a small modification of the code, and a new save-as
add-in, my Excel just wouldn't start. "There was an error starting this
add-in..." and so on. I'm asked to send a report to Microsoft and then
Excel shuts down.

I have unistalled Office and reistalled it again, but still the same
problem. Does anyone have an idea hat I should do next? A register
problem? Restarting in safe mode doesn't help.

Thanks

Martin
 
M

mliungman

I have tried both removing the add-in and putting it back. Excel still
opens and then shuts down with error message.

Martin
 
M

mliungman

I'd love to!

Have no idea what you mean, though. How do I "clean (rebuild) up" m
add-in? The add-in that caused this is the only one I've ever made...

Marti
 
D

Dave Peterson

Start a new workbook.

Copy all the code from the troublesome workbook's project to the new workbook's
project.

Copy all the data in all the worksheets to new worksheets in the new workbook.

Etc, etc, etc.
 
M

mliungman

I managed to figure it out.

I had password protected the entire workbook that I saved as an Add-in
Excel could not handle this and refused to open at all. By opening Exce
while pressing the shift key I could force Excel to run, and I coul
then remove and re-install the Add-in from the Add-in selector.

Marti
 
Top