Hi!

My add-in is password protected. If I open it for editing,
save the changes, close the workbook, when I re-open
the workbook the add-in is still open, i.e. the code still visible.
As I understand it, only by exiting and then re-entering Excel
can you re-enable the add-in password protection.

My question is: is there anyway to close the add-in and re-
institute the password protection when only the workbook
it is attached to is closed (but Excel still running)? I've tried in
Workbook_Close(), but nothing seems to work.

Thanks!


--
robvan
------------------------------------------------------------------------
robvan's Profile: http://www.excelforum.com/member.php...o&userid=14807
View this thread: http://www.excelforum.com/showthread...hreadid=264357