View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phillip Nolan Phillip Nolan is offline
external usenet poster
 
Posts: 1
Default How to Refresh VB Functions Automatically in Excel?

I can define a Visual Basic function (via Tools - Macro - Visual
Basic Editor) and the function is indeed called for all cells
referencing it the first time that I select "Close and Return to
Microsoft Excel."

The problem is that when I re-edit the same function and "Close and
Return to Microsoft Excel" the cells are not updated automatically.

How can I get Excel to refresh my entire page automatically upon saving
my VB function and returning to Excel?