Hello everyone......first time posting on here, so please be gentle!!


Basically what I need done, is when the first Excel workbook is opened you will see a ‘Request Addition’ button on the left of the workbook.

This button then opens a Userform called ‘Additions’ with the form name of ‘frmAdditions’.

The user is then asked to input two separate entries, and must fill in both (if not a pop up messagebox advises them of this). So there will always be two entries. The user then clicks an 'Add' button on the userform.

THIS IS ALL COMPLETE AND IN PLACE, FROM HERE IS WHERE I NEED HELP WITH THE CODE/PROCESS.....

At the moment, I have it set up that when the ‘Add’ button (cmdAdd) is clicked, it offsets the information onto a separate tab in the same Workbook, known as ‘Sheet 1’. This however I have discovered will not work as I need it to Save each time an entry is made. We need the Excel workbook to be protected in such a way that no data on the form can be changed, but the drop down comboboxes are still able to be selected, and can still populate the cells B8-L8 when changed.

Hence the reason I would like it to actually write to a secondary excel workbook instead of an additional tab on Excel. So ideally I would like this to happen:

 ‘Add Button’ pressed
 Secondary Excel Workbook opens in background (unseen and unknown to the user)
 Information from the two entries in the 'Additions' Userform are written into the next available row in the Secondary Excel Workbook
 The Secondary Excel Workbook then Saves automatically, and closes automatically
 The user then clicks the ‘X’ button in the top right to close the first Excel Workbook without being prompted to Save or Save As etc.


Any help anyone can give me would be excellent. As it stands I have been unsuccessful in my attempts to do this. I am very new to VBA, so a well explained answer would be very much appreciated.

Thanks,

Dane