Export to excel- Make sheet Protected

namachi

How to make export to excel sheet protected, Without manually doing it by the user?

Otto

Use Worksheet Automation :
Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)

Check the detail on http://msdn.microsoft.com/en-us/library/bb179210(loband).aspx



I hope this work for you