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