Is there a way by means of a macro a macro can check itself to see if it
has some data entered into it that would normally be entered into say 2
unlocked cells that the user would normally use.

Lets say when you open a file a macro brings up a dialogue box and asks
you to enter 12 lots of 6 digit numbers - when they are entered for the
first time they are saved into the macro never to be requested again
unless the macro is edited and the 12 sets of 6 numbers cleard out.

I have a worksheet that uses a macro to lookup your pc's mac address
and displays it for you within excel - because a mac address is made up
of 12 numbers or letters - ive written a formulae that matches the
character code for each mac character and if the 6 digit number matches
the character set number - unlocks it. When all 12 characters are
matched the overall sheet is unlocked then all the program formula's
can be used using the "if" command that currently works very well.
This system works well if used on the same pc but when used on another
- it locks up stopping the program from working - I want to be able to
hide the 12 sets of 6 digits within the macro itself.


--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=521480