View Single Post
 
Old 01-09-2012, 09:49 AM
namedujour
Guest
 
Posts: n/a
Default

Thank you! That kind of worked.

However, I saved the XLAM add-in with the macros from a password-protected sheet. When I clicked the icons Excel asked for that password and tried to launch that worksheet.

The short keys, however, worked immediately and didn't do that.

I tried to remove the add-in from the spreadsheet, and couldn't find a way to do that. There is no "Delete" in the View and Manage Microsoft Add-ins dialog. So, once you put it there, there it is - unless you remove add-ins somewhere else.

I closed the original spreadsheet and created a new one - the password-protected add-in was attached to the new spreadsheet as well. I closed Excel and reopened it, and the next new spreadsheet I tried to create had that add-in.

So, apparently an add-in you attach to one spreadsheet attaches to every new sheet from that point on. Is that correct? Unfortunately, I need to make it go away so I can set something up without passwords. I'll poke around in Help and see if I can figure that out, unless you have a quick fix...?

Apparently I can't actually display the XLAM sheet to turn off the password. Nothing launches when you try to open it.

I wanted to retest this by creating the add-in from a spreadsheet that had no password. However, the fact that the original add-in attaches to new spreadsheets means I can't.

I can live with the short keys, but it just seems like something isn't working correctly. Did I miss something?

EDITED: I figured out how to disable the add-in. However, when I created the new XLAM add-in from the spreadsheet that has no password protection, the new add-in didn't display on the dialog. I looked and found it in the same AddIns directory as the first add-in, which DOES display in the dialog. So it exists, and when I did a Save As again, it asked me if I wanted to replace the existing file. Still, I can't access it to attach it. So I don't know what's going on, or why it's working this way. I guess I'll just re-record the macros.
Reply With Quote