View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ROland ROland is offline
external usenet poster
 
Posts: 72
Default Refresh Excel cells on demand

I would like to add a button or a menu pick to Excel asking it to refresh all
cells which referances a user defined function in an Add-in.

For example:

Cells
a1
=ExternalData("source1")

a2
=ExternalData("source2")
....

After button click ExternalData should refresh its data.

Any help would be great!

Thanks

Roland