dylan 83
11-08-2005, 07:12 PM
I don?t know if you guys can help me or not.
I am currently building a timesheet for me staff. All the formulas and calculations for the hours are done and work fine. I am currently running one week per work sheet.
All I really want to do now is create a button on the bottom of my sheet. I want the button to lock the entire sheet from editing but still visible then create a new worksheet for next week carrying over the previous YTD information. The new worksheet needs the same style button on it for the same situation for next week and so on.
In the weeks that are current or being used the information on each sheet needs to be protected from editing but visible, although there are drop down lists that my staff use to enter there times.
:dunno
I am currently building a timesheet for me staff. All the formulas and calculations for the hours are done and work fine. I am currently running one week per work sheet.
All I really want to do now is create a button on the bottom of my sheet. I want the button to lock the entire sheet from editing but still visible then create a new worksheet for next week carrying over the previous YTD information. The new worksheet needs the same style button on it for the same situation for next week and so on.
In the weeks that are current or being used the information on each sheet needs to be protected from editing but visible, although there are drop down lists that my staff use to enter there times.
:dunno