UtterAccess.com
We have detected that you are using an unsupported web browser. We recommend you to upgrade your web browser to get the most from UtterAccess forums.
Why should and how can I upgrade?
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Protect Footer And Header In Excel    
 
   
NewExcelChick
post Jun 5 2007, 03:16 PM
Post #1

UtterAccess Addict
Posts: 291
From: USA



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
Go to the top of the page
 
+
fkegley
post Jun 5 2007, 03:42 PM
Post #2

UtterAccess VIP
Posts: 23,630
From: Mississippi



Let's see. Select those cells that the users can change. Then Format--->Cells--->Protection... Clear the checkmark from the box. Click OK.
When Tools--->Protection--->Protect Sheet, use a password, don't forget it, don't share it.
Go to the top of the page
 
+
NewExcelChick
post Jun 5 2007, 03:58 PM
Post #3

UtterAccess Addict
Posts: 291
From: USA



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
Go to the top of the page
 
+
fkegley
post Jun 6 2007, 08:05 AM
Post #4

UtterAccess VIP
Posts: 23,630
From: Mississippi



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.
Go to the top of the page
 
+
NewExcelChick
post Jun 6 2007, 10:18 AM
Post #5

UtterAccess Addict
Posts: 291
From: USA



So I just record a macro to do what I need? or should I put some coding in it?
ks
Liz
Go to the top of the page
 
+
fkegley
post Jun 6 2007, 11:02 AM
Post #6

UtterAccess VIP
Posts: 23,630
From: Mississippi



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.
omething 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.
Go to the top of the page
 
+
NewExcelChick
post Jun 6 2007, 11:32 AM
Post #7

UtterAccess Addict
Posts: 291
From: USA



Great, I got it...thank you Frank..
Have a good week.
Liz
Go to the top of the page
 
+
fkegley
post Jun 6 2007, 12:21 PM
Post #8

UtterAccess VIP
Posts: 23,630
From: Mississippi



You're welcome, Liz. I am glad I could help. You too have a good week.
Go to the top of the page
 
+
fkegley
post Jun 6 2007, 12:21 PM
Post #9

UtterAccess VIP
Posts: 23,630
From: Mississippi



You're welcome, Liz. I am glad I could help. You too have a good week.
Go to the top of the page
 
+

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 



RSS Search  ·  Go to Top  ·  Lo-Fi Version Time is now: 21st October 2014 - 04:29 PM