Add-in Asking to be Saved

[ExcelMonkey]

I created an Addin. I have distributed to several work
collegues to have them test it. They have dowloaded it
into their My Documents folder and then installed it into
Excel via Toool\Addin\Browse\My Documents\Addin file.

I password protected the xla file. However whenever we
close Excel we get prompted if we want to save the changes
to the XLA file. This is confusing as its password
protected. I do not want to five anyone acccess to it.
Yet when I go to the VB Editor and click on the xla it
prompts me for a password.

Furthermore, my one colleague was showing me that although
it was clicked off in the Addin list, it was not appearing
as it should in her Menu items. So we clicked it off and
then on again and the mene item appeared.

Does anyone know what is going on here?

Thanks

 

[Tom Ogilvy]

Does your code make changes to the addin?

If so, that could be the problem on the prompt to save.

 

[Dick Kusleika]

EM

There was a lot of talk about Google Desktop and add-in problems a while
back. I never heard your situation exactly, but it might be something easy
to try and see if you have a new twist on the problem.

http://www.dicks-blog.com/archives/2004/12/11/google-desktop/

 

[ExcelMonkey]

Sorry. I found what the problem was. I had put this code
into it when it was just an xls file. I guess I do not
need it now that it is an xla file. See below:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim Msg As String
Dim Ans As String

If Not Me.Saved Then
Msg = "Do you want to save the changes you made to "
Msg = Msg & Me.Name & "?"
Ans = MsgBox(Msg, vbQuestion + vbYesNoCancel)
Select Case Ans
Case vbYes
Me.Save
Case vbNo
Me.Saved = True
Case vbCancel
Cancel = True
Exit Sub
End Select
End If
Call DeleteMenu

End Sub