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

Hi
uninstall the addin (or close Excel completely)

--
Regards
Frank Kabel
Frankfurt, Germany

"robvan" schrieb im Newsbeitrag
...

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

I'm confused.....easily done<g

An Add-in is not attached to a workbook.

An Add-in is a workbook saved as an *.XLA and loaded through ToolsAdd-ins or
loaded through workbook_open code in a workbook.

Closing a workbook does not unload the Add-in unless you have code in the
workbook to do so.

The only other ways to close an Add-in is to close Excel or go to
ToolsAdd-ins and uncheck the Add-in.

Re-check to load again.

Gord Dibben Excel MVP

On Tue, 28 Sep 2004 14:02:25 -0500, robvan
wrote:


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!