Write in a cell of a locked spreadsheet Using VBA code

Write in a cell of a locked spreadsheet Using VBA code

Hi.

How can I write in a cell of a spreadsheet that is blocked?

I mean:
I need to collect information in a spreadsheet of an user and through a macro (button) this information is sent to the spreadsheet that is blocked for that user.
The user can not write directly to the blocked spreadsheet, but he can enter in another spreadsheet where he enters information.

Can this be possible?

for example:

There are three spreadsheets: Sheet 1, Sheet 2 and Sheet 3.
Sheet 1 is a spreadsheet locked and no one can write directly to it (just me).
Sheet 2 and 3, are unprotected spreadsheets where users can write information, on these sheets there are buttons (macros) that when pressed will send the information collected in sheets 2 and 3 to the sheet 1 that is blocked.