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

A

AlexT

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Strange Title Columns Print Issue 0
Print titles 2
VBA Code to create reminders in Outlook from Excel 0
Problem when trying to set axis properties of a chart by VBA 2
Excel VBA bug? 1
MSExcel and SAP 0
VBA Code needed to AUTOMATE VALIDATION selections and then PRINT EACHNAME dynamically 3
A workbook of macros which runs on external workbooks. 6

Top