macro to execute code from cell.value?

Hi.
I'm trying to create a dynamic custom menu in excel where people can specify their own buttons; eg. the button-names and what they do.

In that scenario, I was wondering if it is possible for a macro-script to call/execute code directly from a cell?

Say for instance that cell A1 in sheet1 has the value:

Please Login or Register  to view this content.

and in a module I have something similar to

Please Login or Register  to view this content.

...
If this is not possible; is it then possible to make a macro that adds a whole new sub-routine? (create codebehind from codebehind sort of speak)
for instance a macro that when run checks if a named sub-routine exists, and then creates a new sub where sub-name = cell-value, code to run = another-cell.value etc?

not easy to try typing code you don't know what is, but I would assume something like:

Please Login or Register  to view this content.

Perhaps the below link will be of interest

http://www.cpearson.com/excel/vbe.aspx

Here would be a quick example:

Please Login or Register  to view this content.

wherein code module is added, executed and then removed.

(requires MS VBA Extensibility Library referenced)

You should find you can incorporate in line with a change event if needed.

I'm not really sure how practical this type of thing is though - the more knowledgeable folk around here might have some caveats to add.