Sarathi_57
Banned
- Joined
- May 2, 2012
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi,
I have a workbook where one of the sheets is password protected. Apart from this, the code is also password protected.
I use a userform to show the "Please wait" message to the user when the code is running.
I use a ADODB connection to the same excel workbook to query the sheet.
My problem is when i close the workbook, the "VBA project password" window is kept opened twice. I need to click "cancel" twice so get rid of this.
I tried looking into many forums and most the answers were related to some Add-ins. I checked everything and there are no add-ins that are enabled.
Apart from this, many forums has answers that "Google desktop" or Acrobat player may cause the problem. But in my case, i dont even have them.
I also read a article that it may be due to memory leaks. If that is the case with my code, then please let me know how to fix this memory leak.
Could someone please help me in fixing this?
Thanks
Sarathi
I have a workbook where one of the sheets is password protected. Apart from this, the code is also password protected.
I use a userform to show the "Please wait" message to the user when the code is running.
I use a ADODB connection to the same excel workbook to query the sheet.
My problem is when i close the workbook, the "VBA project password" window is kept opened twice. I need to click "cancel" twice so get rid of this.
I tried looking into many forums and most the answers were related to some Add-ins. I checked everything and there are no add-ins that are enabled.
Apart from this, many forums has answers that "Google desktop" or Acrobat player may cause the problem. But in my case, i dont even have them.
I also read a article that it may be due to memory leaks. If that is the case with my code, then please let me know how to fix this memory leak.
Could someone please help me in fixing this?
Thanks
Sarathi