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.

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.

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.

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.