Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default reference cell in header

Thanks to the reply to this post:
Subject: what code pulls in contents of a cell in an Excel header/footer?
7/14/2005 12:05 PM PST
I was able to successfully reference a cell in the header of one sheet of my
original document: However the document I have put together asks the users a
series of questions then saves the file under a new name.

Is it possible to have the NEW document that has all the same tabs just a
different file name still retain the background code that references the cell?

(the referenced cell and the sheet name will always remain the same, only
the workbook file name will change)

Using this code in ThisWorkbook frame of VBAProject:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets("PMC").PageSetup.CenterHeader = (Sheets("PMC").Range("b63").Value) &
(Sheets("PMC").Range("b61").Value)

End Sub

I'm getting the custom header original text in the new workbook but with no
code behind it so the information is incorrect.
--
THANKS!

Steve
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
adding cell reference on a header Sima Excel Worksheet Functions 4 March 29th 07 07:14 PM
cell reference in header Dana Excel Discussion (Misc queries) 3 January 30th 07 10:39 PM
Excel header/footer cell reference Paddy Excel Discussion (Misc queries) 2 December 16th 05 04:31 PM
cell reference in header row ML Excel Discussion (Misc queries) 4 August 26th 05 06:30 PM
Cell Reference in Header Dave Excel Discussion (Misc queries) 1 May 20th 05 08:56 PM


All times are GMT +1. The time now is 05:53 PM.

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"