Hi, i have to create a button on an Excel spreadsheet that the user can click on at the end of there shift, Once clicked it will save the document on a network drive in the following format date shift the different shifts are Mornings Afternoons Nights. i dont mind using 3 buttons 1 for each shift.?

I can create the button but i need to know the code that will allow me to do the above.

Thanks John