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.
 

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

Similar Threads

Lotus notes attachment opening return receipt 0
Saving Lotus Notes in Sent Folder vba excel 0
using lotus notes 3
Excel Files to be sent out via Lotus Notes 3
How to bypass password when pasting FROM a protected workbook 3
Send Mail using Lotus Notes 1
Need help on VBA excel macro and API to close an external application 0
Excel/Lotus Notes 2

Back
Top