View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gunti Gunti is offline
external usenet poster
 
Posts: 58
Default Automaticly saving formula's to values when saving

Seeing as i have no experience in creating macro's. Can you make an example
where it saves Sheet1'!A3:A5 and Sheet2'!A3:A5 from a formula to value's when
you save?

Greets & Thanks,
Gunti

"Daniel.C" wrote:

You can use the event procedure "Workbook_BeforeSave".
Regards.
Daniel

Is there any way of doing this in Excel? I want certain (not all) formula's
to become value's when saving a file.