Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / February 2006

Tip: Looking for answers? Try searching our database.

Run Time Error 1004: Please help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BEEJAY - 20 Feb 2006 19:10 GMT
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
Tom Ogilvy - 20 Feb 2006 19:17 GMT
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

Signature

Regards,
Tom Ogilvy

> Option Explicit
>
[quoted text clipped - 37 lines]
>
> End Sub
BEEJAY - 20 Feb 2006 21:11 GMT
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

> Option Explicit
>
[quoted text clipped - 80 lines]
> >
> > End Sub
BEEJAY - 20 Feb 2006 19:19 GMT
SORRY about the duplicate posting - please use other one - Thank you.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.