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

jraj1106 thanks for the input, but im looking more for when the User has the Workbook opened i dont want any of the controls Ribon, File, Home, Insert ..... and rest active.
thats to ensure that the User is not able to go in and start messing with the Workbook beyond filling in the fields of information.

Thanks
Aeneren

AlvaroSiza,

Thank's looked over the link and there is alot there to go over and try to digest it.



Thanks
Aeneren