Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


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
Heaven


Similar Excel Video Tutorials

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







Hello,
i need help locking header and footer as well as page layout options..

I need to password protect or something along that like to do with above mentioned functions for my application...

I am using 2007 and 2003 excel...

Please if any one can help me solve it...


Greetings,

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?

TIA,

Greg


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

Hello,

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!!

Joel


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?

Manoj


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.

regards

jon


Hi,

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.


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.

Thanks!


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.

help?


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


Dear all,

Can anyone tell me how to add a header and footer to a word object created in Excel 2007.

I can easily find the header and footer ribbon icons but they are blanked out

Kindest Regards

Andrew


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 :-

E6:E2500

G6:G2500

P6:P2500

Q6:Q2500

R6:R2500

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.

Thanks
Griffo


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,

Iain.


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!


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.

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.

Thanks!