Hi,

I have a fairly large xl file with plenty of macros (2mb). What I can not figure out is when I save my workbook to a different name using the 'save as' option, I get runtime errors.

First one is it complains about the scroll column proprety I use:
VB Code:
  1. With ActiveWindow 

  2.     .ScrollColumn = incrcol 

  3.     .ScrollRow = 1 

  4. End With

I am assuming when I save my workbook in a different name, the activewindow changes? Is there another way around this?

Second error I get is 'unable to get chart object' from below:
VB Code:
  1. Sheets(currentsheetname).ChartObjects(1).Activate
I get this error for every chart object in my worksheet. Why can't I access it if I save my workbook to another name?

Any help will be greatly appreciated thanks!!