Posted by JUDY on June 14, 2001 6:29 AM
IS THERE A SETTING TO GET THE FILE NAME AND PATH TO PRINT ON ALL SPREADSHEETS?
Posted by Joe Was on June 14, 2001 6:34 AM
Put the formula; =CELL('filename') in any cell in the print range. If I put it in the bottom Right, I format the alignment to Right and change the font size to 8. JSW
Posted by JUDY on June 14, 2001 6:56 AM
IS THERE ANY KIND OF GLOBAL SETTING TO GET ALL SPREADSHEETS TO PRINT THE PATH NAMES.
THANKS FOR YOU HELP
Posted by Eric on June 14, 2001 7:18 AM
You could use the "print header" function to display file name
This won't get the entire path statement, but you can get a header print out of the file name by going into File-->Print Preview and click on "Setup" then select the "Header/Footer" tab. Click on the drop down list for the header and you'll see that one of the options is the name of the file. I know that if you create one sheet and make these changes to the print settings, you can copy the sheet and the settings will copy as well, but I don't know if there is a global command to change all of the sheets in a workbook at once. Hope that helps.
Posted by Joe Was on June 14, 2001 8:45 AM
Only four ways
The four ways are:
1. Cell('filename') in a sheet cell.
2. Header, footer page code.
3. Sheet Tab code, puts item #1 in automatically, in a preset sheet cell.
4.Macro to set #1 or #2 on print.
Excel has no global setting for this function! JSW
Posted by Judy on June 14, 2001 10:05 AM
Thanks for your help!!!!!!!!!!!!