Using a cell but not beeing able to write in it

1. Select the developer tab.

Start your Macro Recorder

Select your cell with the formula

Click into the formula bar at the top of excel and then press enter.

Stop the Macro Recorder.

2. Select the developer tab
Select run Maco
Select Macro1 and the EDIT.

You should see something like:

Please Login or Register  to view this content.

Edit that code to something like:

Please Login or Register  to view this content.

Copy that code and close the Macro Module.

Right Click on the Sheet Name at the bottom of excel and select view code

A module will open.

Select the Listbox at the top left that Says General. Make that read Worksheet.

Select the Listbox at the top Right that Says SelectionChange. Make that read Change.

You will see this code:

Please Login or Register  to view this content.

Paste your Macro in the middle of that code and then close the Module:

Please Login or Register  to view this content.

Ok you are done. From Now on it is impossible to change the formula in your cell.