| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet_Calculate event and input data
-horatiu-
This eliminates the chart selection. The active cell location should remain unchanged... Private Sub Worksheet_Calculate() Me.ChartObjects("Chart 7").Chart.Axes(xlValue).MaximumScale = _ Me.ChartObjects("Chart2").Chart.Axes(xlValue).Maxi mumScale End Sub -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Horatiu" wrote in message Jim, this is not what I had in mind. I need to go back to the default worksheet behaviour. -horatiu- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using excel to manage event - ANY input deeply appreciated! :-) | Excel Discussion (Misc queries) | |||
| Worksheet_Calculate event problem | Excel Programming | |||
| A procedure should run when one cell switch between false/true - but not with worksheet_calculate or change event... | Excel Programming | |||
| Input Box Cancel Event | Excel Programming | |||
| dynamically changing chart y axis using spin buttons and worksheet_calculate event | Excel Programming | |||
Threaded Mode
