View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default change formula in a shared worksheet without losing change his

DCE
This code will check if a file exists and or is open, that way you will know
it is active before you start to do any modifications to it before the user
saves it.

HTH
Mark.

http://www.rondebruin.nl/exist.htm