View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
mantrid mantrid is offline
external usenet poster
 
Posts: 15
Default using VBA on protected sheets, is it possible?

Hello
I am having problems using the VB code below (which basically copies and
inserts a row) to work on a protected sheet, despite the protection being
set to allow insertion of rows. It works fine when sheet is unprotected. Is
there a way around this

With ActiveSheet
..Rows(rowno - 1).Copy
..Rows(rowno - 1).Insert (xlShiftDown)
..Paste Destination:=ActiveSheet.Rows(rowno)
End With

Thanks
Ian