Firstly, I would like to say that your website is excellent. I have had some pretty detailed questions, but you were able to figure them out, cuddo's.
I have the following macro:
Sub Copying()
'
' Copying Macro
' Macro recorded 5/12/2002 by DETER
'
'
ActiveWindow.SmallScroll ToRight:=-1
Sheets("Working Database").Select
ActiveWindow.SmallScroll ToRight:=2
ActiveWindow.ScrollColumn = 1
Range("A1:G5250").Select
Selection.Copy
Sheets("IO Database").Select
Range("A3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub
This macro works fine. What I want to do is hide the actual worksheet named "Working Database", with protection. But when I do this, and run the macro, it indicates a run time error becuase it can not find the worksheet. What do I need to change in the macro above for it to work on the hidden sheet?
Any help would be appreciative.
I have the following macro:
Sub Copying()
'
' Copying Macro
' Macro recorded 5/12/2002 by DETER
'
'
ActiveWindow.SmallScroll ToRight:=-1
Sheets("Working Database").Select
ActiveWindow.SmallScroll ToRight:=2
ActiveWindow.ScrollColumn = 1
Range("A1:G5250").Select
Selection.Copy
Sheets("IO Database").Select
Range("A3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
End Sub
This macro works fine. What I want to do is hide the actual worksheet named "Working Database", with protection. But when I do this, and run the macro, it indicates a run time error becuase it can not find the worksheet. What do I need to change in the macro above for it to work on the hidden sheet?
Any help would be appreciative.