Thread: My Macros will not work after I protect my document.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Samantha Samantha is offline
external usenet poster
  
Posts: 24
Default My Macros will not work after I protect my document.
Sub Create_New_Entry()

Rows("24:24").Select
Selection.Insert Shift:=xlDown
Range("E23:R23").Select
Selection.AutoFill Destination:=Range("E23:R24"), Type:=xlFillDefault
Range("B24").Select
End Sub

Reply With QuoteReply With Quote