Wanna make a Userform Close and Save - Then open a different workbook?

Which workbook is the userform in?

If it's WB1 surely the workbook is already open.

What does your current code do/not do?

Userform is in WB2 - And i guess WB1 would still be open either way. The thing is for my purposes I wouldnt need to do any of this. The only reason i DO need to do it is coz around 100 of my collegues are going to be using this and well...although i dont have a lot of VBA/Excel experience, I know that when sharing a sheet to the masses, somebody always knackers it up.

WB1 is a communications and guidance hub containing lots of links to intranet pages, internal guidance notes and all sorts which is why I want it read only to protect the sheet being corrupted by 'Joey No IT Skills'? The sheet with the Userform and where the date gets writtin too is a Questions and answers sheet...userform lets them add the date their name and their question - again so that they dont have to meddle and mess stuff up (formatting, formula etc)....I guess im not making a lot of sense?

oh and my code works great so far - will copy the textbox entries to the sheet (WB2) saves it and closes it - what it doesnt do is then go back to WB1. It needs to close WB2 after question submitted coz then it "locks everyone else out for editting". Am i over thinking this?

Edit: Just re read my message back again and I just want to clarify that because of the read only issue - I then instead decided to have the data be posted to an new workbook which is what WB2 is - so to clarify the data is not being sent to WB1 anymore its going to WB2 so that I can have WB1 read only and WB2 Write enabled to allow the userform to write the data.

I'm a little confused, how are the workbooks connected?

Also, have you tried opening WB1 before you close WB2

Sorry I'm totally lost here.

You have WB1 which is the 'hub', is that where the userform is opened from? Is WB2 opened at the same time?

What thing do you want the userform to do?

I thought it was putting data in WB2 which wasn't read only.

It sounds to me that you already have WB1 open so all you need to do is close WB2.

Trying to get it as 'automated' as possible.

WB1 has a button which opens up WB2. WB2 has a question and answers table on sheet1. A button at the top of the table opens the Userform. Userform pastes date name and question to table in sheet1 and then saves WB2 and closes WB2. Yes WB1 would remain open the whole time but I want to somehow guarantee that once WB2 has saved and closed that it goes straight back to WB1 (I.e if there are also other workbooks open in the same instance of excel then I dont want it to go to one of those pages instead)

I guess there is probably a much simpler way of achieving my aim but this is just the only way I can think of to protect the sheets in WB1 (the hub) with read only and have a sheet that can have data inserted and saved.