2 questions 1 time in cell 2 header protection

K

Karl

Hi I would like to be able to put just the time in a cell where it updates
itself everytime the sheet it accessed,I know the date is =Today() but not
sure about time alone. Question 2 I would like to be able to protect the
header/footer so it can't be changed by anyone but me. Thanks in advance Karl
 
D

Dave Peterson

I don't think you can protect that (seems kind of weird, huh).

But you could reapply the headers/footers each time the worksheet is printed.

If you record a macro while you're setting up the headers/footers for each
worksheet, you could have that code get called each time anything is printed.

If your recorded macro is called mySetupMacro (name it whatever you like), then
you could have the _beforeprint event just reset all those settings to what you
like.

Behind the ThisWorkbook Module:

Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Call mySetupMacro
End Sub

And in a general module would be your code.

Post back with your question if need help tweaking the recorded macro.
 
Top