Inserting a row in excel 2000 although the worksheet is protected

  • Thread starter Thread starter bartman1980
  • Start date Start date
B

bartman1980

Does somebody know if I can 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 2007 errors on chart changes 1
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Protection greyed out in Excel 2
Excel 2000 protected worksheets problem 2
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Controlling worksheet protection via VBA 0
Run macro on all files in a specific folder 3
Worksheet copying in Excel 2007 3

Back
Top