View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default I need a macro that saves a spreadsheet on two drive at once,

I'm thinking you could put this in a Workbook_BeforeSave event. I've never
done it. You may want to ask in the Programming group.

"Chauncy_G" wrote:

I need a way to save a spreadsheet on two different drives at once, (1 for
backup). Ideally this will be done with the minimum of moves, one button or
cloick would be nice.