auto lock

Hello All, Can anyone help with auto locking cells when the saved button is pushed. I used the code from the following thread, but the thread has since gone dark: http://www.mrexcel.com/forum/excel-questions/686259-auto-lock-cells-after-data-entry-when-file-saved.html My problem is similar...

I am a REAL novice at this and am asking for your kind assistance in getting this going. I've created a vehicle sign out log (as shown below). 1. Column "B" is where student will select their names (simple drop down menu); 2. Column "C" is where the student will enter their driver's license...

Hello, Experts I am a REAL novice at this and am asking for your kind assistance in getting this going. I've created a vehicle sign out log (as shown below). 1. Column "B" is where student will select their names (simple drop down menu); 2. Column "C" is where the student will enter their...

Hi , I have an excel workbook with 12 worksheets. each worksheet is password protected. I know the password, after I unlock the sheets and save&close, when i open again the sheets are locked, I would like the sheets to be unlocked even after exit, can any one help me please Thanks in advance;

Hi, I'm creating a document (Excel 2010) where employees open the file and book time off by filling out the columns. I have a code which automatically locks any cells containing data upon saving so an employee is able to enter the days they want off without changing anyone else's entries which...

Hii, Gyus I am using following codes for current time and current date in sheets, Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 2 And Target.Column <> 5 Then Exit Sub Application.EnableEvents = False Target.Offset(0, -1).Value = Date Target.Offset(0, 1).Value = Now -...