vbaExcel2_6
New Member
- Joined
- Aug 28, 2009
- Messages
- 1
I have couple of VBA programming related question:
1) I have created spreadsheet with VBA macros and have put password protection on the VBA project. It runs fine and does what it is supposed to do but after I close the spreadsheet (the instance of Excel is still open) the VBA project associated with the spreadsheet doesn't go away. If I repoen that spreadsheet in the same instance I see 2 VBA projects with the same name. How do I get reed of VBA project when I close the spreadsheet that has the VBA project under question?
2) Sometimes for the same spreadsheet if I close the instance of Excel i.e. not just closing the spreadsheet, the VBA project password window pops up asking to enter password. How do I stop this from happening?
1) I have created spreadsheet with VBA macros and have put password protection on the VBA project. It runs fine and does what it is supposed to do but after I close the spreadsheet (the instance of Excel is still open) the VBA project associated with the spreadsheet doesn't go away. If I repoen that spreadsheet in the same instance I see 2 VBA projects with the same name. How do I get reed of VBA project when I close the spreadsheet that has the VBA project under question?
2) Sometimes for the same spreadsheet if I close the instance of Excel i.e. not just closing the spreadsheet, the VBA project password window pops up asking to enter password. How do I stop this from happening?
