How to make a worksheet non editable ...even file extension change

R

Radha Krishnan

I can make a worksheet non editable by using the worksheet property
objExcelSheet.EnableSelection = XlEnableSelection.xlNoSelection

also i am using the Protect document option with password.
The xls file cannot be able to edit. The document protection is achieved good.

The only problem that i am facing is If the xls file is changed to another
excel file extension say .ods (Open Office Excel document) the protection is
breaked. The password is not retained. The user can just uncheck the Protect
document sheet and can able to edit the document.

How to overcome this issue..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make a worksheet Non-Editable even if extension is changed 1
Make "File in use" message appear when 2 people open the a shared document in the same time 3
How to make one standard "extension" in a column? 5
Creating a non-editable merged word file 0
Excel 2013 cannot open simple text file with .acc extension 1
Excel changes file extension on embedded object upon save 1
How to change format protection default to unlocked? 2
How secure is Excel 2007 worksheet protection? 1

Top