| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make a worksheet Non-Editable even if extension is changed
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.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a worksheet non editable ...even file extension change | Excel Discussion (Misc queries) | |||
| how to make Excel linked to SQL Server 2005 worksheet editable? | Excel Discussion (Misc queries) | |||
| How to make combobox non-editable? | Excel Programming | |||
| How to make cell not editable | Excel Worksheet Functions | |||
| How do I make editable PDF forms using Excel? | New Users to Excel | |||
![Radha Krishnan[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
