Error with macro after recording
 

Hi all
I have some error and don't know how to resolve it. Basically I did record a
workbook with 10 worksheets. I make changes of graphic in each worksheet and
move to another worksheet. When running again I had some errors below.

Windows("sheetname1.xls").ScrollColumn = 15

ActiveWindow.SmallScroll ToRight:=3

Any idea to fix this are welcome
Daniel

Error with macro after recording
 

Those are lines that captured you moving the spreadsheet on the screen
with either your mouse or scrollbar. You should be able to remove
them completely with no ill effects.
Daniel wrote:
Hi all
I have some error and don't know how to resolve it. Basically I did record a
workbook with 10 worksheets. I make changes of graphic in each worksheet and
move to another worksheet. When running again I had some errors below.

Windows("sheetname1.xls").ScrollColumn = 15

ActiveWindow.SmallScroll ToRight:=3

Any idea to fix this are welcome
Daniel

Error with macro after recording
 

Thanks but how do I know which lines are capture when moving by mouse or
scrollbar?
Thanks
Daniel
"JW" wrote:

Those are lines that captured you moving the spreadsheet on the screen
with either your mouse or scrollbar. You should be able to remove
them completely with no ill effects.
Daniel wrote:
Hi all
I have some error and don't know how to resolve it. Basically I did record a
workbook with 10 worksheets. I make changes of graphic in each worksheet and
move to another worksheet. When running again I had some errors below.

Windows("sheetname1.xls").ScrollColumn = 15

ActiveWindow.SmallScroll ToRight:=3

Any idea to fix this are welcome
Daniel