Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code doesn't work from in Office 2003
Private Sub Worksheet_Calculate() Application.EnableEvents = False 'your code Application.EnableEvents = True End Sub If this post helps click Yes --------------- Jacob Skaria "Dennis Cheung" wrote: The following code worked fine in office xp but not in 2003 Private Sub Worksheet_Calculate() Application.EnableEvents = True Run ("SelectAfter") Application.EnableEvents = True End Sub The problem is when I tried to unhide rows in the sheet, the marco "SelectAfter" runs. And I only need it runs when somethng changed in PVT. It worked fine in XP version but above situiation happened after I changed to 2003. The marco SelectAfter means to hide 2 rows after select other items in PVT. Can someone help? -- Dennis Cheung |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ms office 2003 excel does not work well on vista | Excel Discussion (Misc queries) | |||
Can you open Office 2007 docs in Office 2003 from code? | Excel Programming | |||
VBA does not work for Office 2003 | Excel Discussion (Misc queries) | |||
Office 2003 PIA do not work for Office 2000 | Excel Programming | |||
VB scripts from Office 97 that no longer work in Office 2003 | Excel Programming |