| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does formatting raise an event
Hi
I've noticed several examples in this NG, and elsewhere, in which events are disabled whilst applying cell formats, eg code to extend Excel's limit of 3 conditional formats and apply color. Does formatting ever raise any events, and if not is there any reason to disable events if the code only changes formats? TIA Sandy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Does formatting raise an event
Hi Chip
Thanks for clarifying that, Sandy -----Original Message----- Sandy, No, changing the format of a cell does not trigger a change event. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Sandy V" wrote in message ... Hi I've noticed several examples in this NG, and elsewhere, in which events are disabled whilst applying cell formats, eg code to extend Excel's limit of 3 conditional formats and apply color. Does formatting ever raise any events, and if not is there any reason to disable events if the code only changes formats? TIA Sandy . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I raise a matrix to a power? | Excel Discussion (Misc queries) | |||
| Which 'event' to run pivot chart formatting code on file open? | Charts and Charting in Excel | |||
| Raise numbers in the same proportion.. | Excel Discussion (Misc queries) | |||
| Raise Values by 25% | Excel Discussion (Misc queries) | |||
| dialog raise event? | Excel Programming | |||
![Sandy V[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
