Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

How To Lock Header Footer Excel 2007

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi Guys

Please help me if you know how to lock header footer in excel 2007. And if you also know how to lock some certain ribbon control options so that form users cannot use them. For example, Insert - Text etc. And also locking . Quick Access Toolbar locking?

Many thanks

View Answers     

Similar Excel Tutorials

Make Users Enable Macros in Order to View a Workbook in Excel
Tutorial showing you how to make a user enable macros in a workbook in order to view the workbook. This is very im ...
Dynamic Named Range in Excel
How to create a named range that expands automatically when a new value is added to the range. This is a great lit ...
Scale Data for Printing in Excel - Fit more onto a Printed Page
This tip shows you how to fit more Excel data onto a page for printing. This does not change the size, shape, or lo ...
Password Protect Excel Files
How to keep an Excel workbook safe by encrypting it with a password. This will make it so that a user cannot open ...

Helpful Excel Macros

Delete a VBA Module From Excel
- Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Excel.
Sort Data With Headers in Ascending Order in Excel
- Macro that sorts data that has headers in ascending order in Excel. This macro assumes that you data has headers on it.
Display the AutoFilter Criteria Applied to a Data Set in a Cell in Excel - UDF
- This free Excel UDF (user defined function) allows you display the filter criteria that has been applied to a data set i
WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
- This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week in the year on which a particular
Delete Empty Columns
- This macro will delete columns which are completely empty. This means that if there is no data within the entire column

Similar Topics


Quick Excel Header/Footer question. When I print worksheets the header and footer size is not consistent. When creating the header and footer, I have them all set to the same font size....when I print, the more data that's on a worksheet the smaller the printed text becomes on the header/footer. How do I lock it in at a consistent printed font size no matter what's on my worksheet?



I have this Excel file that I get periodically and I need to print it in my own printhead letter. Thus, I need to add a fixed header&footer.
Of course, I don't have to do this with every excel file I get, therefore I am thinking about a button in the quicktoolbar that I click when I want to add that specific Header&Footer.

I have 2 issues so far:
1) Although there's no image in my footer & header, The footer is longer than 255 chars, and apparently Excel doesn't allow more than those. I have different fonts & size in the header and footer themselves.
2) I managed to save the header & footer I want as images (from Word) in an Excel file, but then I don't know the VBA code to tell Excel "open this file and copy its footer and header".

I tried to search on the forum and over the internet but no luck so far. Any help?
Thanks guys!

How do I lock excel header footer for no change


I am trying to find a way to insert a custom header and footer that I have to use for all company documents into excel. The current options under the header and footer tools in excel do not achieve this. The header and footer I am using has 3 and 8 fields consecutively, contains a logo, borders, filepath etc, dates, revisions, pages, etc. Does anyone know of anyway to create a truly custom header and footer in excel? I apprciate any help, thanks!!


I have a question about locking in cells or rows in a spreadsheet.

I am working on a Telephone Number Listing, which spans dozens of excel pages. I want to lock in the row that I have the heading descriptions in, so that if a row is added (such as a new employee) or one is deleted (someone leaves) the headings stay where they are, and the rest of the info moves down a row, or onto the next page, if appropriate. Is this even possible?

I know excel has a header and footer option like Word, but the way the sheet is set up, it is not appropriate (see below example)

hi, i was wondering if anyone could help me on how to release a record lock while it is being modify (in edit mode)?

i have an Excel macro that will connect to MS Access database by using DAO, at the beginning of my codes i have also implemented row-locking by using ADO (because DAO by default is page locking)

each time when user retrieve a record from the database, the macro will lock that particular row so that other users can't modify it. i have used "recordset.edit" to lock a record, it works fine

however, right now my concern is that what if a user retrieved a record and locked it for a long time (or somehow the user's pc got hang or something), there is no way for me and other users to modify or to release the lock

i have tried using "dbengine.idle dbfreelocks" but it doesn't seems to work, is there any way using VBA (in Excel or Access) to unlock a record while a user is modifying (in edit mode)??

or maybe is there a way that i can open up the MS Access database and do something to release the lock?

thank you.

Dear All

I want to customise my header Footer by providing Names

as say center header : company name below that Annexure I

Left Footer: Place: aaaa below that Date: 30/05/2007
right footer: Name: abcd below that Designation: aaaaa

I want to provide these names in say a1 to a6 (center header a1 & a2, left footer a3 & a4, right footer a5 & a6)

how can I go about this?



As one of my project requirement, I need to add my own custom header/footer into the predifined list of header/footers in the pagesetup dialogue window.

I know, I could do that by adding custom header/footer manually but that added header/footer get lost once I select any other header/footer.
I want to keep that added header/footer as persistent field as other are populating in that dropdown list.

Please let me know the solution, if anybody knows.

Thanks in advance

Amit Jain

Not sure if anyone can help me with this one but I figured I would give it a try. I'm using MS Word 2003 SP3. When selecting Insert -> AutoText -> you are given another pop up menu however if I select any of the options (Attention Line, Closing, Header/Footer,...) I should get an additional pop up that would allow me to do something like insert a Header/Footer.
I can select all they way down to Header/Footer but can not go any further as I do not have any options after that.
I have gone as far as to have my Office re-installed on my computer and still no joy.
Anything you can provide would be very helpfull. Thank you in advance.

Is it possible to lock a whole tab except some chosen cells. Im using excel 2003 and finding I can lock a tab, a workbook or a single cell. I wish to lock a Page (Tab) except for one cell so employees can change this to show figures.

Reason for it locking - people keep removing long formulas relating to other tabs.



Hey guys, I'm running excel 2007 at work and need to lock over a hundred pages that are on this one .xlsx file, yet I don't have access to the IRM tools because my company won't allow me to install anything on the computer.

Is there any sort of macro or other technique short of locking each individual page?

Any advice or direction would be greatly appreciated.


I accidentally clicked "insert" >> "header and footer" in my excel 2007 file. Now I'm not able to delete or remove that header and footer box. It says "click to add header"..

Can this be done? I have tried a couple of things and it just does not seem to wortk...
Column A1 has a Date in it.
What I would like to do is Link A1 to the Header or footer, can this be done??
Also I would like to Format how the Header reads.
So if A1 had a date lets say 10-01-2007.
I would like the Headre or footer of the sheet to read October 2007...
Can this be done????

I unlocked the document and selected several cells but when I lock the document ... it's all or nothing.

I'd like to lock cells like the header and footer information.


Hey anyone,

I am trying to lock my worksheet but I dont want to lock the checkboxes. I tryied checking the box "Allow users to edit objects" but it still gave me an error when I tried it.

Please help

I'm trying to use the following code I got from he

to be able to insert a header/footer into the new document from excel. Is it possible to be able to insert a custom header/footer ie:Company logo with text into a new word document? ie could the header and footer be in excel to be added each time a new document is opened?

posted here but not exactly what I needed:

Hi All

Some help please

I have a table of data which i need to extract into a csv text file at the click of a button. This data then needs to be imported into another system

Sadly its not as straightforward as it sounds, but i'm hoping someone can advise me.

Basically the table has 19 columns, the first 9 need to become a header line and the remaining 10 repeated as many times as required below. Only one header record to be shown though (as the header record will remain constant on the table)

So the csv file output will need to look as follows

Header = Columns 1, 2, 3, 4 ,5, 6, 7, 8, 9
Footer = Columns , 10, 11, 12, 13, 14, 15,16,17,18,19
Footer = Columns , 10, 11, 12, 13, 14, 15,16,17,18,19
Footer = Columns , 10, 11, 12, 13, 14, 15,16,17,18,19
Footer = Columns , 10, 11, 12, 13, 14, 15,16,17,18,19
Footer = Columns , 10, 11, 12, 13, 14, 15,16,17,18,19
Footer = Columns , 10, 11, 12, 13, 14, 15,16,17,18,19

I do not require the headers for any of the records and no gaps between any lines (including the header and footer)

Many thanks

Hi All,

I want to lock particular cells of my sheet.

For Example :-






When i am locking these cells, other cells of sheet doesnt provide me options like Insert comment, format cells.

Is there any way where i can lock above mentioned cells and my other cells function like normal(Unlocked)

Hi there

Is it possible to use a value from a cell in a header or footer in Excel 2007.

I've searched the board and google without success.

The value I want to use is on a different worksheet to the one with the header.


I am trying to lock out a worksheet with option buttons (radio buttons).

I have password "Protected" the worksheet to prevent editing, but the radio buttons can still be changed.

I have been into the "Format Control" for each button and the "Group box" and ticked the "Lock" and "Lock text" in the protection panel, but the buttons can still be changed.

Any ideas what is stopping me locking down the "option buttons" so they can not be changed?

I would very much appreciate and help or advice.

Kind regards,


How do I lock specific cells in MS Excel 2007? I've tried Format/lock cell and then format/protect sheet - but can only lock worksheet and not specific cells! Help?

I have a strange problem that I haven't been able to find help on. I have an excel document with over 30 sheets. All I need to do is insert a footer on all pages.
I'm using Office 2007 (ha....maybe that's the problem)
I've tried highlighting all sheets, clicking the insert tab, then header and footer. I can insert a header, but the "Go to Footer" tab is not active and when I click on it nothing happens.
I've tried highlighting only one sheet and had the same issue.
A blank Excel document does not have this problem and I can add footers with no problem.

Another thing is I have no idea how to change the page breaks on multiple worksheets at the same time. In the past, I could highlight all worksheets and drag the page break of one, but when more than one worksheet is open I cannot click and drag the pagebreak..... I only ask because the one time I managed to somehow put in the footer, all the pagebreaks were changed on all sheets....

Anyway....I'm sure it's user error and I just have to spend the next year or so relearning how to use all the fancy 2007 stuff, but would greatly appreciate anyone's help.


Hey guys

I want to insert a pic on my sheets and just lock the pic i.e. user not allowed to edit/move/delete the pic. One of the sheets has a pivot table in it. Any ideas how I can do this without restricting functionality in the pivot? Locking the sheet restricts pivot functionality - user not allowed to group items

I tried inserting the pic as a header, this works but is not available in the "Normal" view, which is where users will work and I want them to see the pic (as well as have the pic printed if the sheet is printed)

Many many thanks!

Hi Guys

I want to set Left header,Center header,Left footer,Center footer and right Footer in the sheet that gets printed off when a button is clicked on the userform.
So I want the following header n footer:

Left Header: Recorded Delivery Consignment

* Now the date in above will come from the userform comboboxes as Format(DateSerial(ComboBox3, ComboBox2, ComboBox1), "dd/mm/yyyy")
Center Header: AXA Company ,London

Left Footer: Total number of records:

* In above footer on each sheet will store total number of records so count function will be used.
Center Footer: Accepting Officer Signatu ........
Right Footer: Date:

Many Thanks

How does one lock certain columns in a spreadsheet without locking the entire tab? I've gone through countless attempts and each result in the entire sheet being locked. I'm using '07. I've tried it both with and without checking the "Lock Cell" under the Cells>Format on the ribbon.

Also, does "un-checked" mean it IS NOT highlighted? Again I've tried it both highlighted and un-highlighted.