Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security Signature
I have a medical charting form that requires filling in one row and then initialing the column next to it. For instance, if the nurse takes a blood pressure, they would log it in A1 and initial in A2. These two columns represent one day. At this time the form must be printed, filled in and filed. With medical records it is critical to track what was done, who did it, and to whom. And each procedure must be initialed by the one doing it. What I would like to do is do this digitally, then on a weekly basis print the form, sign it and file it. Usually the same nurse is charting for the day/shift they work but there may be a different one charting either a different shift or day. I need a way of making them only place their initials on the work they did. (Not that they would intentionally cheat). I was thinking one-way would be to have a macro to require an ID to log into the form, and then somehow an €œIF€ statement that would read the ID and automatically enter the initials based on the ID. Or a larger macro that would enter the initials into any selected cell or cells, again based in the sign-in ID. This will work as long as no one shares his or her ID. Another way might be with a vlookup, but dont know if there is a way to maintain a certain level of security. I can do a simple IF statement (because there would never be more then 7 people charting), but I feel this is too easy to get around. Any ideas? Mike Rogers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet Security | Excel Discussion (Misc queries) | |||
Macro Security | Excel Discussion (Misc queries) | |||
how to raise the Macro security level in a product I can't execute | Excel Discussion (Misc queries) | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) |