Run Time Error 1004: Please help

G

Guest

Option Explicit

Private Sub REmove_Net_Pricing_Info_Click()

' SelectButton Macro
' Macro recorded 2/20/2006 by JFS
' Delete TP Contract References to Pricing (Customer Copy),
' so it can be added to Trailer Contract
'
Dim ws As Worksheet
Application.ScreenUpdating = False
For Each ws In ActiveWorkbook.Worksheets
If ws.ProtectContents = True Then
ws.Unprotect ("Fern")
End If

Next
ActiveWorkbook.Unprotect (["Ferd"])

Sheets("Options").Select
Range("C6").Select
Selection.ClearContents
Range("H6:I6").Select
Selection.ClearContents

Sheets("Pricing").Select
Range("C120").Select
Selection.ClearContents
Range("C121").Select
Selection.ClearContents

Sheets("Contract").Select
Range("B1").Select

If ws.ProtectContents = False Then
ws.Protect ("Fern")
End If

Application.ScreenUpdating = True

End Sub
 
T

Tom Ogilvy

Option Explicit

Private Sub REmove_Net_Pricing_Info_Click()

' SelectButton Macro
' Macro recorded 2/20/2006 by JFS
' Delete TP Contract References to Pricing (Customer Copy),
' so it can be added to Trailer Contract
'
Dim ws As Worksheet
Application.ScreenUpdating = False
For Each ws In ActiveWorkbook.Worksheets
If ws.ProtectContents = True Then
ws.Unprotect ("Fern")
End If

Next
ActiveWorkbook.Unprotect (["Ferd"])

Sheets("Options").Select
Range("C6").Select
Selection.ClearContents
Range("H6:I6").Select
Selection.ClearContents

Sheets("Pricing").Select
Range("C120").Select
Selection.ClearContents
Range("C121").Select
Selection.ClearContents

Sheets("Contract").Select
Range("B1").Select

for each ws in ActiveWorkbook.Worksheets
If ws.ProtectContents = False Then
ws.Protect ("Fern")
End If
Next
Application.ScreenUpdating = True

End Sub
 
G

Guest

Thanks, Tom, for the prompt response.
Sorry this one got sent before I completed my comments
- I hit the right button at the wrong time, I guess.

I added your input to that received from the other post and got it going.
Thanks Again.
jfs

Tom Ogilvy said:
Option Explicit

Private Sub REmove_Net_Pricing_Info_Click()

' SelectButton Macro
' Macro recorded 2/20/2006 by JFS
' Delete TP Contract References to Pricing (Customer Copy),
' so it can be added to Trailer Contract
'
Dim ws As Worksheet
Application.ScreenUpdating = False
For Each ws In ActiveWorkbook.Worksheets
If ws.ProtectContents = True Then
ws.Unprotect ("Fern")
End If

Next
ActiveWorkbook.Unprotect (["Ferd"])

Sheets("Options").Select
Range("C6").Select
Selection.ClearContents
Range("H6:I6").Select
Selection.ClearContents

Sheets("Pricing").Select
Range("C120").Select
Selection.ClearContents
Range("C121").Select
Selection.ClearContents

Sheets("Contract").Select
Range("B1").Select

for each ws in ActiveWorkbook.Worksheets
If ws.ProtectContents = False Then
ws.Protect ("Fern")
End If
Next
Application.ScreenUpdating = True

End Sub

--
Regards,
Tom Ogilvy


BEEJAY said:
Option Explicit

Private Sub REmove_Net_Pricing_Info_Click()

' SelectButton Macro
' Macro recorded 2/20/2006 by JFS
' Delete TP Contract References to Pricing (Customer Copy),
' so it can be added to Trailer Contract
'
Dim ws As Worksheet
Application.ScreenUpdating = False
For Each ws In ActiveWorkbook.Worksheets
If ws.ProtectContents = True Then
ws.Unprotect ("Fern")
End If

Next
ActiveWorkbook.Unprotect (["Ferd"])

Sheets("Options").Select
Range("C6").Select
Selection.ClearContents
Range("H6:I6").Select
Selection.ClearContents

Sheets("Pricing").Select
Range("C120").Select
Selection.ClearContents
Range("C121").Select
Selection.ClearContents

Sheets("Contract").Select
Range("B1").Select

If ws.ProtectContents = False Then
ws.Protect ("Fern")
End If

Application.ScreenUpdating = True

End Sub
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Time Error 1004: Please Help 3
Run Time Error 6
Run Time Error 1004: Application or Object Defined Error 4
Deactivate macros but reactivate again once another macro is run 2
Run macro from active workbook whose name keeps changing 20
run-time error 1004 - VBA Gurus Please Help 12
Run-Time Error '1004' 13
Problem with password security 8

Top