Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In password is requested when closing Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In password is requested when closing Excel
Most likely you have google desktop search installed. Checkout
http://www.add-ins.com/password_problem.htm for a solution. Bob Flanagan Macro Systems 144 Dewberry Drive Hockessin, Delaware, U.S. 19707 Phone: 302-234-9857, cell 302-584-1771 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "cgr" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add-In password is requested when closing Excel
Bob,
Thanks for the information. The Google Add-In is not installed on this machine. CGR "Bob Flanagan" wrote: Most likely you have google desktop search installed. Checkout http://www.add-ins.com/password_problem.htm for a solution. Bob Flanagan Macro Systems 144 Dewberry Drive Hockessin, Delaware, U.S. 19707 Phone: 302-234-9857, cell 302-584-1771 http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "cgr" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help requested for Excel Iteration problem | Excel Discussion (Misc queries) | |||
Password prompt appears when closing Excel | Excel Programming | |||
Excel 2003 when closing Excel after having opened a project locked for viewing.. password prompt??? | Excel Discussion (Misc queries) | |||
Help requested for an Excel Toolbar command | Excel Discussion (Misc queries) | |||
Add-In Password when closing Excel. | Excel Programming |