VBA Code password error

Tony12zz

Board Regular
Joined
Feb 21, 2004
Messages
56
I have protected the VBA code by setting a password, however when I close my excel down it asks for the VBA password even though I did not attempt to go into the VBA code when excel was open. I then have to click the cancel button several times to get rid of password prompt box.

I right clicked on the project to go into VBA project properties and ticked the box and entered the pasword.

Has anybody come across this issue before?

I have not tried it on a different PC yet.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Tony12zz

Board Regular
Joined
Feb 21, 2004
Messages
56
I am having trouble following the Microsoft help page to resolve the problem I should

“design classes in your ActiveX DLL so that workbook references are properly released before the classes terminate”

can anybody advise what my ActiveX DLL is !?, my spreadsheet is a few user forms with code behind them. There is also code behind some the individual sheets.
:biggrin:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,322
Messages
5,769,451
Members
425,548
Latest member
macjagger17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top