![]() Second: The path to where the Workbook template should be stored is: Regards, Bob J.įirst I felt like an idiot, it worked just fine when I tried again and I was thinking what I did differently from the first try.įirst: There is no user access to Excel's default (built-in) template. The Sheet template also has to have the H/F imposed when you save it.ĪI: Artificial Intelligence or Automated Idiocy? Please mark Yes/No as to whether a Reply answers your question. You also create the Sheet file referred to in JE's original reply. Likewise, no H/F will be included with any new sheets you add to workbooks based on the custom template unless Each Sheet in the template needs to have them imposed. The file must be saved in the correct locationĪlso, don't forget that Headers/Footers are specific to each individual sheet in a workbook. ![]() Even if you exclude the extension when you name the file in the Save As dialog the program will stillĪppend it when the file is written to disk. Note: The extension has to be removed in Finder after the file has been saved. ![]() The file must be saved as an Excel Macro-Enabled Template (.xltm).Once the file has been modified the way you want it, including the Custom Header & Footer Not to be argumentative, but it works fine here :-) I'd suggest you recheck the key points.
0 Comments
Leave a Reply. |