All the sheets are protected with password, therefore I´ts also necessary
to unprotect, and then protect the sheets in that same code.

Assuming they were all unprotected at the time.

--
Don Guillett
SalesAid Software

"liddlem " wrote in message
...
Hi Jonsson
Provided that you want to insert a row at the same place on ALL your
worksheets, you could use the following code.

'Select multiple worksheets.
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select

Select and insert the row that you wish
Sheets("Sheet1").Activate
Rows("3:3").Select
Selection.Insert Shift:=xlDown

One row has been inserted into each of the worksheets.
Hope this helps


---
Message posted from http://www.ExcelForum.com/