View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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.