| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to avoid being asked for a VBA password on workbook close?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to avoid being asked for a VBA password on workbook close?
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 On May 28, 8:57*am, wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to avoid being asked for a VBA password on workbook close?
Have a look at this article it may give you some guidance.
http://support.microsoft.com/kb/280454 -- jb " wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable Password Dialog Close Workbook | Excel Programming | |||
| Suddenly Asked for Password on Tools/References | Excel Programming | |||
| Macro - asked username & password and sign into Yahoo Finance | Excel Programming | |||
| User asked for VBA project password | Excel Programming | |||
| Open en close a workbook with password | Excel Programming | |||
Linear Mode
