Save in one click a Shape in Excel work book

May 1, 2012 at 1:56 PM

Hi, I want to create a Excel work book which have 4 to 20 sheets, and have a Shape where I click and save the work book in another location which I indicate the location. Can it possible in Excel? If have any code please mention the same and guide step by step, so I can create the same.