All,

I'm trying to put a password to my header and footer in Excel files, so people can make changes to numbers but not make changes to the footer and header.

Any suggestions?

Tls

Liz

Let's see. Select those cells that the users can change. Then Format--->Cells--->Protection... Clear the checkmark from the box. Click OK.

Then Tools--->Protection--->Protect Sheet, use a password, don't forget it, don't share it.

Hello Frank, How are you?

Thank you and I do that for the cells in the spreadsheet, but then I go to View, Header and Footer, choose Footer, and I enter information like, who prepared the file, date, time, time changed etc..) and I don't want people to be able to make changes to the Footer or Header, and I was wondering if there was a way to protect the footer only. ALso do you know a way to make the footer to repeat the same information for all spreadsheets? I have a file with 20 spreadsheets or tabs, and I have to make changes to 20 Footers, so I was wondering if there was a way to change all of them at once.

Anyway, the important thing is try to protect the Footer to prevent changes from somebody else, is it possible?

Thank you again for helping me out.

Liz

Oh, I see. You could use a macro to do that, couldn't you? It would need to iterate thru all the worksheets in the workbook and change the footer of each. I don't think there is a good way to protect the footer aside from taking all buttons off the toolbars, but you could add code to the relevant This Workbook events to run the macro, that is the macro would set the footers for all sheets back to whatever you want them to be, no matter what changes the user makes to the sheets.

Yes, my testing seems to confirm that that will work.

So I just record a macro to do what I need? or should I put some coding in it?

Tks

Liz

I just recorded a macro to do one footer. Then I think you will need some code to cause the macro to run for each worksheet in the workbook.

Something like this

Dim sh As Worksheet

For Each sh In ActiveWorkbook.Sheets
Module1.Macro1
Next sh

Where macro1 is obviously the macro that sets the footer values.

Great, I got it...thank you Frank..

have a good week.

Liz

You're welcome, Liz. I am glad I could help. You too have a good week.

You're welcome, Liz. I am glad I could help. You too have a good week.