How to avoid being asked for a VBA password on workbook close?

P

phpons

Hi all,

I have a workbook with VBA code that is protected with a password.
I use the workbook, and when I close it, I get a message box that asks
for the project password!!

How can I get rid of this "behavior"?

TIA,

Philippe
 
P

paul.robinson

Hi
Is there some code in the Workbook_BeforeClose event that is calling
the form? In the Editor, go to the ThisWorkBook code module.
regards
Paul
 

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

How to bypass password when pasting FROM a protected workbook 3
Excel prompts for VBA password when opening 5
VBA Password - Excel keeps prompting for it 0
VBA Password Workaround 1
VBA Password box appearing at close 4
workbook open password protected 3
Setting up Solver reference in a protected VBA project 1
Programmaticlly sign and password protect a VBA Project in Excel 2 6

Top