Inserting a row in excel 2000 although the worksheet is protected
 

Does somebody know if I can Inserting a row in excel 2000 although the
worksheet is protected?

Inserting a row in excel 2000 although the worksheet is protected
 

Yes
1) unprotect the sheet in your code, insert the row, protect the sheet
2) use the UserInterfaceOnly property of the protect method which allows
code to make changes to a protected sheet.

--
Regards,
Tom Ogilvy


"bartman1980" wrote:

Does somebody know if I can Inserting a row in excel 2000 although the
worksheet is protected?