Prompted for VBA password when closing Excel with "Lotus Notes Qui

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Back
Top