Hi all,

This solution would probably work better with a user form but i'm
relatively new at VBA so am avoiding user forms right now....

I have a worksheet where users have to enter in produce delivered,
quantities etc. When items have been entered an "Archive" macro is run
to keep all the info.
What i need is something that when a user runs the macro, he/she is
promted to enter a password. This password is then copied to any cells
where say Range.(A) is a non null value.

E.g:

Date Product Signature

04/12/05 A

04/12/05 B

In this case when the macro is run, the user enters a password (from a
list sourced hidden elsewhere off the page), verifies the password is
valid and pastes either the password or username to the Signature
column. THen when everything is archived it can be determined who
checked those items.

Any help is much appreciated - as always and always!

Thanks in advance,

Chris


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=490702