Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Functions that Change Other Cells
There seems to be some kind of security that prevents a function called from a worksheet changing other cells (on that sheet or anyother). Is there anyway to get around that? I'm hopeing to update a range of cells when the sheet calculates without using the "onCalcluate" event. In fact I know that it's possible because I use a thrid party product that does just this. How it does it is somewhat of a mistery to all of us. To hopefully make myself clearer if I call this function: Public Function timesTheyAreAChanging() As String timesTheyAreAChanging = "Time" Range("A3") = Now() End Function From a worksheet using: "=timesTheyAreAChanging()" then it returns an error result. Yet if I comment-out the line that changes another cell then it works fine. This is obviously a simple example what I want to do is much more complex but the problem remains the same. - Rm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up worksheet where cells change monthly | Excel Worksheet Functions | |||
how can i change the colum width for cells on the same worksheet | Excel Discussion (Misc queries) | |||
Worksheet Functions that Change Other Cells | Excel Programming | |||
How to make a function change other cells in worksheet | Excel Programming | |||
worksheet functions change to values? Formula are text? | Excel Programming |