Problems calling macros from "ThisWorkbook"

[blesbok]

I am trying to call a macro from a sheet using thisworkbook, however, I don't think it allows this. Therefore as a solution I just recopied the macro that I was using into "thisworkbook". However, the 'Sheets("Charts").ChartObjects("Chart " & r).SeriesCollection(1).XValues = ' command does not seem to be recognized in this object, so now I am unable to autoupdate the charts which was the whole reason for this whole process. Any help in either getting that command to work in "thisworkbook" or allowing me to call a macro from a sheet using "thisworkbook" would be greatly appreciated.

[blesbok]

No one has any ideas?

[Dave Peterson]

I had difficulty understanding the question.

But if the procedure is behind a worksheet, you could use:

Option Explicit
Public Sub mySub()
MsgBox "hi from the sheet"
End Sub

And call it via:
Option Explicit
Private Sub Workbook_Open()
Call Sheet1.mySub
End Sub

If the procedure is in ThisWorkbook:
Option Explicit
Public Sub mySub()
MsgBox "hi from thisworkbook"
End Sub

and called elsewhere (from a sheet or general module):
Option Explicit
Sub other_sub()
Call ThisWorkbook.mySub
End Sub

But I think moving general procedures to General modules is the best/safest bet.





blesbok wrote:
>
> No one has any ideas?
>
> --
> blesbok
> ------------------------------------------------------------------------
> blesbok's Profile: http://www.excelforum.com/member.php...o&userid=30635
> View this thread: http://www.excelforum.com/showthread...hreadid=502891

--

Dave Peterson