Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompted for VBA password when closing Excel with "Lotus Notes Qui
Hi, can anybody help me on this?
I have a protected Excel file, when I have installed "Lotus Notes QuickR" and try to close the Excel file I was prompted to provide the VBA password. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompted for VBA password when closing Excel with "Lotus Notes Qui
ben,
I had same problem with my VBA project. My problem was due to using the SET statement to assign a reference to Thisworkbook. eg: Set mybook = Thisworkbook what I neglected to do at then end of the procedure was add: Set mybook = Nothing This line solved my problem. hope of some help to you. -- JB "Ben" wrote: Hi, can anybody help me on this? I have a protected Excel file, when I have installed "Lotus Notes QuickR" and try to close the Excel file I was prompted to provide the VBA password. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompted for VBA password when closing Excel with "Lotus Notes
Hi John,
Thank you for your replay. Befor installing "Lotus Notes QuickR" every thing was working fine. No prompt for the password. I had a similar problem with google search and I have changed a flag in the registry. It was a bug in Google search. Maybe "Lotus Notes QuickR" have changed something in the registrey too. "john" wrote: ben, I had same problem with my VBA project. My problem was due to using the SET statement to assign a reference to Thisworkbook. eg: Set mybook = Thisworkbook what I neglected to do at then end of the procedure was add: Set mybook = Nothing This line solved my problem. hope of some help to you. -- JB "Ben" wrote: Hi, can anybody help me on this? I have a protected Excel file, when I have installed "Lotus Notes QuickR" and try to close the Excel file I was prompted to provide the VBA password. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompted for VBA password when closing Excel with "Lotus Notes
Ben,
Sorry but I have no experience with Lotus Notes. You may find the following article of interest. http://support.microsoft.com/kb/280454 -- JB "Ben" wrote: Hi John, Thank you for your replay. Befor installing "Lotus Notes QuickR" every thing was working fine. No prompt for the password. I had a similar problem with google search and I have changed a flag in the registry. It was a bug in Google search. Maybe "Lotus Notes QuickR" have changed something in the registrey too. "john" wrote: ben, I had same problem with my VBA project. My problem was due to using the SET statement to assign a reference to Thisworkbook. eg: Set mybook = Thisworkbook what I neglected to do at then end of the procedure was add: Set mybook = Nothing This line solved my problem. hope of some help to you. -- JB "Ben" wrote: Hi, can anybody help me on this? I have a protected Excel file, when I have installed "Lotus Notes QuickR" and try to close the Excel file I was prompted to provide the VBA password. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail über Lotus Notes aus Excel heraus/ Sending Mail with Excel through Lotus Notes | Excel Programming | |||
"Save" macro problem, still prompted to save when closing workbook (?) | Excel Programming | |||
"Activeworkbook" function not valid when workbook embedded in Lotus Notes? | Excel Programming | |||
Lotus Notes - Can't do multiple "Send Tos" | Excel Programming | |||
Excel/Lotus Notes | Excel Programming |