Thread
:
Inserting rows macro
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Inserting rows macro
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/
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]