View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michelle Michelle is offline
external usenet poster
 
Posts: 204
Default Can I force my UD Functions to recalculate?

I have a project with lots of functions, which I didn't make 'volatile' (I
realise now, that that was a mistake).

I want the users of the spreadsheet to be able to press a key or take an
action which will make the functions recalculate.

For reasons that are too involved to mention here, I don't want to add any
code to the functions now.

I just want to provide the user with an action they can take to make
everything update.

F9, Tools-options-CalcNow don't work. Any ideas?

Thanks
M