Is there anyway I can protect the header footer area in a worksheet? Thanks Peek
P Peekabeaux Jan 14, 2008 #1 Is there anyway I can protect the header footer area in a worksheet? Thanks Peek
D Dave Peterson Jan 14, 2008 #2 I don't think so. If it's really important to you, you could use a workbook_beforeprint event macro that recreates the header/footer each time print (or print preview is invoked). But this will fail if the user disables macros or even disables events.
I don't think so. If it's really important to you, you could use a workbook_beforeprint event macro that recreates the header/footer each time print (or print preview is invoked). But this will fail if the user disables macros or even disables events.
