Very Interesting read only excel. is there any one who can help me...

[PKAgarwal]

Hi ,

I have a sheet. I need to make it read only.. I need to do something that no one should be able to edit any thing in that particular sheet using macros ..


Please help.

 

[royUK]

Protect the sheet then.

 

[PKAgarwal]

Hi,
how to do that using vba...can you please share the code.

 

[royUK]

I'm not sure what you mean. If you protect the sheet then it can't be changed. What exactly do you want to do?