Auto Date with Manual Entry Protection
 

I am using Microsoft Office Pro 2003, and am working with a spreadsheet that
is located in a shared directory accessible to nearly all users at the
company for which I work. The computer literacy of the employees ranges from
'zero experience' to 'expert', so I don't have the luxury of having all
options available to me with this spreadsheet. For example, the problem I'm
having, I decided to solve with creating a macro. Unfortunately, the default
security setting is 'High' for all users, and I simply can't ask everyone to
lower their security settings. So, macros are out of the question, I'm
guessing.

Anyway, what I'm trying to do is: Column D of the spreadsheet is a
"description" column, and Column C of the spreadsheet is the "date" column.
I am looking to have this spreadsheet automatically enter just the date in
column C when data is entered into column D. I need the date to be entered
into the cell in column C directly to the left of the cell in Column D in
which they're entering a description. There are several catches, though. I
don't want this to be a volatile function, to where the date is re-entered
every time the spreadsheet is opened. I have to be able to track when the
data was *actually* entered. Additionally, I need to protect Column C from
manual entry, while still allowing the date to be automatically entered when
a description is entered into column D. Also, I need this to be able to work
for all users, with High security settings, without requiring password input.


Basically, I just need to make sure the date is automatically recorded,
ensure they cannot alter the date (I can't allow back-dating), and make sure
the date *never* changes once automatically entered. If I think of anything
I've left out, I'll post again.

Thank you for your time, everyone. After staring at this for a few hours,
I'm a bit desperate.

Auto Date with Manual Entry Protection
 

you will have to use a macro to unprotect the sheet copy and paste the system
date and protect the sheet again based on worksheet event with a digital
signature
--
paul

remove nospam for email addy!



"JBallance" wrote:

I am using Microsoft Office Pro 2003, and am working with a spreadsheet that
is located in a shared directory accessible to nearly all users at the
company for which I work. The computer literacy of the employees ranges from
'zero experience' to 'expert', so I don't have the luxury of having all
options available to me with this spreadsheet. For example, the problem I'm
having, I decided to solve with creating a macro. Unfortunately, the default
security setting is 'High' for all users, and I simply can't ask everyone to
lower their security settings. So, macros are out of the question, I'm
guessing.

Anyway, what I'm trying to do is: Column D of the spreadsheet is a
"description" column, and Column C of the spreadsheet is the "date" column.
I am looking to have this spreadsheet automatically enter just the date in
column C when data is entered into column D. I need the date to be entered
into the cell in column C directly to the left of the cell in Column D in
which they're entering a description. There are several catches, though. I
don't want this to be a volatile function, to where the date is re-entered
every time the spreadsheet is opened. I have to be able to track when the
data was *actually* entered. Additionally, I need to protect Column C from
manual entry, while still allowing the date to be automatically entered when
a description is entered into column D. Also, I need this to be able to work
for all users, with High security settings, without requiring password input.


Basically, I just need to make sure the date is automatically recorded,
ensure they cannot alter the date (I can't allow back-dating), and make sure
the date *never* changes once automatically entered. If I think of anything
I've left out, I'll post again.

Thank you for your time, everyone. After staring at this for a few hours,
I'm a bit desperate.