Custom Headers

Paul-Johnson · Mar 12th, 2002, 06:15 PM

Is it possible to have a custom header reference a cell in a worksheet without VB ?

I should know this - but I forget

smozgur · Mar 13th, 2002, 01:52 AM

Unfortunately you cant (at least MS Help Says that)

"You cannot insert graphics or cell references in a header or footer."

You will need VBA.
You can visit TheWordExpert for VBA help and also other office applications

regards
suat

Paul-Johnson · Mar 13th, 2002, 04:20 AM

Thanks for your response - I saw the same in the hep section. But, Ididn't know if anyonefound a trick. Similar to Data validation with the data on a different sheet.

Many thanks

PJ

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 06:15 PM	#1
Paul-Johnson New Member Join Date: Feb 2002 Posts: 47	Is it possible to have a custom header reference a cell in a worksheet without VB ? I should know this - but I forget

Mar 13th, 2002, 01:52 AM	#2
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Unfortunately you cant (at least MS Help Says that) "You cannot insert graphics or cell references in a header or footer." You will need VBA. You can visit TheWordExpert for VBA help and also other office applications regards suat

Mar 13th, 2002, 04:20 AM	#3
Paul-Johnson New Member Join Date: Feb 2002 Posts: 47	Thanks for your response - I saw the same in the hep section. But, Ididn't know if anyonefound a trick. Similar to Data validation with the data on a different sheet. Many thanks PJ