unable to set the numberformat property of the range class error

Hi,

i am getting error "unable to set the numberformat property of the range class" after protecting the excel used range.

[code]

Sub TimeStamp()
ActiveCell.Value = Time
ActiveCell.NumberFormat = "h:mm:ss"
End Sub
[\code]

am getting error at ActiveCell.NumberFormat = "h:mm:ss"

can anyone let me know how to resolve this.

Please Login or Register  to view this content.

Hi,

Still i am getting same error after making changes.


Thanks

Hi,

I tried the same at my home and still getting the same error, in my office its not possible to change the format as i dont have aadmin access.

is there any other way i can do it.

actually once again i will let you know what exactly i am trying do, i am trying to lock the used cell in excel i.e once the data is entered in to any cell that cell should get locked and editing should be prohibited , when i am trying with below code entire sheet is getting locked once saved but what i am looking is cell based , i mean once the data entered in any cell that perticular cell should get locked from editing not the entire sheet.

Please Login or Register  to view this content.

please let me know if you need any further info.