Hallo everyone,
I am a novice with VBA and macros and was wondering if anyone can help me out with the following;
I have 2 sheets (labeled “Timesheet” and “Formula”) for calculating team timesheets. I want both sheets to be protected as I do not want users to edit formula and formats. I then need one/two macro(s) to allow users to be able to add new a row if a new employee joins the team or delete the respective row if an employee leaves the team. i.e.
1. Unprotect both the sheets (same password for both: toyota1)
2. Insert a row by short cut (ctrl + r) below the active cell in the same location on both the “Timesheet” and “Formula” Sheets.
3. Copy formatting down from row above to new row.
4. Copy formula down to new row.
5. Protect both sheets again.
And / or also
1. Unprotect both sheets
2. Delete the row that contains the active cell by short cut (ctrl + w) in the same location on both sheets
3. Protect both sheets again.
I would be grateful for any help
Cheers
Proposed TimeSheet Template6.xlsx
Bookmarks