Author Topic: Sheet Titles and Background Borders  (Read 2586 times)

0 Members and 1 Guest are viewing this topic.

doone

  • Jr. Member
  • **
  • Posts: 12
Sheet Titles and Background Borders
« on: September 22, 2017, 10:55:57 AM »
Hi Everyone,

I know this topic has come up many times over the years, but I don’t think it has been truly solved yet (or least that I can find) for this scenario.  I need to have a title block/border on a Background page that will support different sheet titles and other info.  That is, each Page has its own unique title that can be rather lengthy.
 
I found this post http://visguy.com/vgforum/index.php?topic=6470.msg26778#msg26778 where the poster needs the same thing I’m looking for, but he was able to solve the problem with VBA.  I would think there is a way to accomplish this strictly in the ShapeSheets.

The closest that I have gotten is to place =GUARD(Pages[Page-2]!ThePage!Prop.Sheet_Title) in the Background page.  The problem is that “Page-2” needs to dynamic – something like CurrentPage.

I’m tempted to just put a text box on each page with a field =GUARD(Prop.Sheet_Title) as a workaround.

Any ideas?
Thanks in advance.