ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   code does not work when opening again (https://www.excelbanter.com/excel-programming/369314-code-does-not-work-when-opening-again.html)

tweety127[_31_]

code does not work when opening again
 

why is it my worksheet event procedure code does not run when i open it
again? but before i close it it is working, i saved the file.....this
confuses me.....


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=568073


Jim Thomlinson

code does not work when opening again
 
You need to post some code for ust to check. A few questions though. Are you
sure that your code is not running? Put a message box first thing in the
Workbook_Open procedure to verify that it really is not running. Also do you
toggle the Application.EnableEvents to false at any point without turning it
back on. This setting will persist until code returns it to true...
--
HTH...

Jim Thomlinson


"tweety127" wrote:


why is it my worksheet event procedure code does not run when i open it
again? but before i close it it is working, i saved the file.....this
confuses me.....


--
tweety127
------------------------------------------------------------------------
tweety127's Profile: http://www.excelforum.com/member.php...o&userid=34673
View this thread: http://www.excelforum.com/showthread...hreadid=568073




All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com