Assigning a macro

D

deepakj

I have created an excel sheet to track attendance for my team and i have
told my team members to update their attance when they come into
office. However i do not want to give them the option of editing their
attendance status for the previous day except for the current day.
Request you to please guide me step by step on how to create a macro so
that the previous days data becomes non-editable.

Warm regards

Deepak J
 
J

Jonathan Rynd

I have created an excel sheet to track attendance for my team and i have
told my team members to update their attance when they come into
office. However i do not want to give them the option of editing their
attendance status for the previous day except for the current day.
Request you to please guide me step by step on how to create a macro so
that the previous days data becomes non-editable.
Click to expand...

Could you please give some more details about how your sheets are
organized?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autolock a cell after entering value into it 6
Individual vacation calendars in a team resource 0
master - sub project with sub basline and sub budget 0
Loop Macro to edit Date 0
Macro/Formula for auto date insertion 0
Styles Across Multiple Documents 1
Error on Self-Assign Team Tasks page 0
Access Database 4

Top