Add-In password is requested when closing Excel

G

Guest

If I execute the following VBA Add-In Userform1 and Module1 code a number of
times and then exit Excel, I will be prompted to provide a password.

I'm running Excel 2000 and Windows XP SP2.



'---------- Form Code (UserForm1) ----------

Option Explicit


Private Sub cmdCancel_Click()

Me.Hide

End Sub

Private Sub cmdOK_Click()

Me.Hide

End Sub

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)

If CloseMode = vbFormCode Then Exit Sub

Cancel = True
Me.Hide

End Sub


'---------- Code Module ((Module1) ----------

Option Explicit



Public Sub OpenClose()

Load UserForm1

UserForm1.Show

Unload UserForm1

Set UserForm1 = Nothing

End Sub
 
G

Guest

Bob,

Thanks for the information.

The Google Add-In is not installed on this machine.


CGR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top