View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
om om is offline
external usenet poster
 
Posts: 18
Default Save on sheet shift

Hi there

I am new to this VBA, but i will try to give it a go.

I would like the workbook to be saved when the user shifts away from Sheet1
to be certain that content of Sheet1 is always saved.

I suppose that the piece of code should be placed in a VBA module under the
workbook

Thanks Ole