All Excel sheet protections work with X-Author for Excel provided the password for each protected sheet has been entered. Any worksheets that have been protected will be displayed in the Protect Sheet Setting window. Enter the password for each sheet and click Save.

All the options of the protection settings are now supported per sheet. The protection settings are remembered (per sheet) even if you unprotect the sheets. The protection settings are reapplied when you re-protect the sheets back. X-Author for Excel will not allow the addition of rows or columns in a protected sheet.