Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
LouErc
 
Posts: n/a
Default Can you link a custom property to an Excel custom header text?


Lets say I have a custom header called <ArtifactSubject and this is defined
in the right section. Can I link this to a custom property or some other
document content (Source) so that when the custom property changes or
whatever it is linked too this would change the content of the
<ArtifactSubject defined in the custom header. Similar to the way Word does
with its custom properties that are assigned to Fields that can be defined in
a header.

If this cannot be done, I assume the only way I can do it is by manipulating
the PageSetup.RightHeader text assuming I want to use a macro driven function
that would gather the value for the <ArtifactSubject from some form and
update the header text with it.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link pictures in Excel 2003 doesn't work! ODI Excel Discussion (Misc queries) 4 November 5th 05 02:23 PM
How can I using Excel custom document properties in the header? ecalvo Excel Worksheet Functions 4 November 3rd 05 09:29 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
How do I set Excel cell format to "Text" from VB.NET? John Brock Excel Discussion (Misc queries) 8 July 26th 05 04:36 AM
make custom header and footer in excel apply to all worksheets Alexandra Excel Discussion (Misc queries) 1 May 27th 05 06:11 PM


All times are GMT +1. The time now is 04:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"