I've written some code and assigned it to a command button (not the
ActiveX one), which works fine.
It adds a new dataset to a database, once the new information entered
is not part of the database yet.

Is there any way to disable the macro from running, once this newly
entered information is already stored in the database?

Basically I need some code for this:

If G6="not defined yet" then run the macro code
otherwise not

Thanks for your help!

Norbert