Converting formula to static code

[gavster]

I am currently using the following code on a spreadsheet:

Please Login or Register  to view this content.

I'd like to put this into a macro, and based on what I have gleamed, it should look something like this:

Please Login or Register  to view this content.

Is this correct?

What I would also like is that once the entry is made, for it to remain static unless the entry in column F is changed. Can this be done?

Many thanks,
Gavin.

[mudraker]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[gavster]

I've tried your solution, but cannot seem to get it to work.

My full code is:

Please Login or Register  to view this content.

Any further ideas?

Gavin.

[gavster]

Now sorted....

finally worked out mudrakers reply.

Please Login or Register  to view this content.

Thanks.
gavin.