Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a UDF named Test() written below.
And I put it into Sheet1.A1 : = Test() And I activate Sheet2 and press Ctrl + Alt + F9 (CalculateFull). Then a msgbox is shown : 'There is a circulation reference....' I want to turn around the msgbox. (I tried setting Apllication.DisplayAlerts property to false in vain.) '---------UDF ------------------------------- Function TEST() If Not Application.Caller.Parent Is ActiveSheet Then TEST = Application.Caller.Value Exit Function End If TEST = Format(Now, "HH:MM:SS") End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn off R1C1 reference type in Excel 2007? | Excel Worksheet Functions | |||
How do I turn off page reference in page break preview | Excel Discussion (Misc queries) | |||
library circulation function | New Users to Excel | |||
How turn on excel functn, dbleclick on cell 2 show reference? | Setting up and Configuration of Excel | |||
Code to automatically turn on and turn off Track Changes | Excel Programming |