Export to excel- Make sheet Protected

namachinamachi Member Posts: 2
How to make export to excel sheet protected, Without manually doing it by the user?

Comments

  • OttoOtto Member Posts: 17
    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
Sign In or Register to comment.