| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_onChange that shows/hides rows crashes after printing?
I have a simple onChange handler that shows/hides a series of 4 groups
of rows based on values in a given range. I've already tried wrapping the entire block with events = false, and intersect of the key values... the spreadsheet works perfect fine until I print, but after I print, even though the onchange only fires once (proven via MsgBox), the program hangs for a good 15-20 for an subsequent onchange event. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table shows all rows in selection | Excel Discussion (Misc queries) | |||
| Write a macro that hides rows based on empty cells | Excel Discussion (Misc queries) | |||
| Why does my Excel shows the rows and the columns as numbers? | Excel Discussion (Misc queries) | |||
| Excel crashes while trying to save, add or delete rows | Excel Discussion (Misc queries) | |||
| Worksheet that only shows rows with quantity greater than zero | Excel Discussion (Misc queries) | |||
Linear Mode
