Hello Everybody. How is your Friday?

Okay, is it possible, using a recordable Macro or VBA, to change a
worksheet's functionality?

For instance, I have a workbook with one Formatted Data Entry sheet and one
No-Format Archive sheet that stores all the raw data (no formulas) for future
retrieve. Is it possible to change the Data Entry sheet from user input mode
to archive retrieval mode?

In data entry mode, Column D and G are blank to allow for user input. In
archive mode, Column D and G would need formulas which grabbed data from the
corresponding cells on the archive sheet.

The solution should also be able to lock/unlock those cells accordingly.

Can this be done?

Thanks for your time and help.

Arlen