header/footer

Hello, I'm still a beginner with VBA/macros but I've done my head in trying to work out the following two questions on my own so anyone's help would be greatly appreciated. I have a workbook with a number of worksheets, many of which have a worksheet specific named range for a cell called...

Hi all, Does anyone know if there would be a way to reshape or remove page setup headers that will exclude the last page of an active sheet? I currently have this macro inputting text "Page not used" when the data in each worksheet is oddly numbered. This makes an empty "dummy page" (as I am...

I use a template to create different spreadsheets with different information but use 1 macro to sort this information and do various things. One thing i have not figured out how to do at the end of my macro is to have the Header/footer option popup. The header always has a different name so. How...

I feel a bit silly asking and assume I am missing something but I applied a header and footer to my Excel workbook and saved the document when I opened it again both were gone. I checked print preview and they did not show up there and also under view selected page layout that shows an empty...