2k7: Setting print titles in VBA - bug or feature ?
 

A wierd one...

I have some code that defines print titles in a worksheet:

myWorksheet.PageSetup.PrintTitleRows = "$1:$6"

This works fine when running said code within an interactive session.

However I also have to run this macro while running Excel as a COM
object from another "master" process (say a whs script). In that case
the above code doesn't seem to work (no error but the print title is
simply flushed from the worksheet).

Out of despair I have also tried

myWorksheet.Parent.Names.Add Name:="Print_titles",
RefersToLocal:="MySheetName!$1:$6"

to no avail...

Any idea / suggestion would be most appreciated !

--alexT