Macro to open workbook, change cell value and save

Hi.
i'm looking for a code to do the following:

First i'll have a workbook called ACTIVATE with only one sheet (let's call it MENU)
In this sheet MENU on cell C5 i will write a number or anything
Then i need a macro (so i can execute it from this workbook ACTIVATION) that will do the following:
1. First, open a specific workbook called Product.xlsm which is in the same folder as the ACTIVATE.xlsm workbook;
2. Second go to this workbook sheet called FIRST (sheet) and unprotect this sheet with the password "1234"
3. Third, after unprotect the FIRST sheet, the macro should copy and past the value of the cell C5 from workbook ACTIVATE.xlsm into the cell E75 of FIRST sheet from Product.xlsm workbook.
4. After this, this macro should protect the sheet FIRST with the same password again "1234", save and close the workbook Product.xlsm.

Is this possible?
I think it is... i just dont know how to put it in code.

Can someone help please?

Thank you.

Not tested, but it should work :

Please Login or Register  to view this content.

@GC Excel

Thank you for the reply. This code works really well except for one thing:
In the workbook Product.xlsm where i want to past the content from cell C5 from the other wb, i want it to past only the values and not the cell itself.
This code is copying the cell color and font color too and i need it to stay exactly in the same color as is set in Product.xlsm (so it stay hidden in the background - i put the font in the same color as the cell background in Product.xlsm).
And as the code is itself right now it copies and pastes but takes out the format i have in the other workbook.
I attatched a picture so you can see what is happening.

Thank you for the help you already gave.

Change this line :

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Now its absolutly PERFECT!

Many thanks

Regards