Forum Discussion
Remove File Extension in Custom Header in an Excel Sheet
Hello Ingeborg, Thanks
Can I use this code for all types of workbooks, be it .xlsx or .xltx? Do I need to save the workbook as .xlsm, i.e as macro-enabled workbook? If so, how can use .xlsm workbook as a template?
Hello,
if you use this approach, the workbook must be saved as a macro-enabled workbook, i.e. with either the .xlsm or .xlsb file extension.
You can create a template that contains this macro by saving the file as a macro-enabled template with the .xltm extension.
- Thanks a ton! I'll connect back if I need any further assistance. Cheers! :D
In continuation of my reply a few minutes back. I got a very simple solution from another forum. Change the view options in Windows Explorer, the file extension display changes accordingly & that too instantly. No need for macros.
Hiding the file extension on the whole computer is an option, but it's all or nothing. I like to see file extensions, but maybe not in the header or footer of a printout.