Coding to have a Button to save a Workbook

Hello All,

Couple Questions for you Excell masters:

1. is there a way to turn off the Ribbon and "File, Home, Insert ....." Tab's when a Workbook is opened so only the Spread sheet is visible ??

2. I've been looking through the forum's for a way to have a Clean Workbook opened, data entered by the User and then saved on the click of a command button with certain Information from the Work book itself and once its saved the Workbook then Closes and is a Clean Workbook again ready for the next day's inventory.

ive attached a small version of the Workbook for a refrence

Any Assisstance is Appreciated



Thanks, Aeneren