| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| opening excel spreadsheet but it didnt save my last work | Excel Discussion (Misc queries) | |||
| excel crash when opening work book | Excel Discussion (Misc queries) | |||
| Opening an excel workbook doesnt work | Excel Programming | |||
| run code on opening workbook and apply code to certain sheets | Excel Programming | |||
| Some menus don't work opening xls in IE 6.0 | Excel Programming | |||
![tweety127[_31_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
