protect add-in after workbook closes
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 |
protect add-in after workbook closes
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 |
protect add-in after workbook closes
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! |
All times are GMT +1. The time now is 06:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com