Hi all

I'd like users to be able to insert rows into my protected workshee
witghout having to unprotect it first.

Therefore I've got a command button on the sheet and I'd like it t
when clicked:

1. unprotect the sheet using my password "jon"
2. insert rows for me (I've already asked the user to select the row
he's like to have inserted, i.e. selected using the row numbers on th
left of the screen. For example if they want to insert a copy of row
through 7 below row 7 then they have selected rows 4-7 and they hav
turned black)
3. protect the sheet again using my password "jon"

I've got the following so far, but don't know what to put in the middl
to make the INSERT ROWS bit happen.

CommandButton1.TakeFocusOnClick = False
ActiveSheet.Unprotect Password:="jon"
--WHAT DO I PUT IN HERE??--
ActiveSheet.Protect Password:="jon"

Any ideas?? Many thanks in advance for your help

Jo

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