Yes, you can use VBA but it is still not "protecting" the header or footer, rather it is overriding it during printing. If you have many worksheets...
Maybe you can protect the workbook. This will prevent hidden worksheets from being displayed.
@c patel Maybe you could post your file. Protect=Userinterface Only works for me when enabling or disabling autofilter via VBA.
@ Laurie-E Protection is only meant to prevent accidental entering of data and not 100% full proof. As I know, what you ask may not be possible (no...
Seems like this question was also posted in
Hi Justmeok Try this. I just removed some parenthesis from your formula and wrapped it in an IFERROR to display 0 =IFERROR(IF(L$4>$D$1,VLOOKU...
Since you need to override your data you should use what Frans suggested i.e. create a new sheet with an empty Table every month. I use both overri...
Hi Rakesh Give this a try. I have added a Helper column in column E. It is for the search of the 3-column combination. My macro was written t...
A brilliant idea Phil
Have you considered using a Table for the data? The range will auto expand when new data is added.No formulas involved. Then you only need to refre...
Hi Amy Give this a try and see if this is what you want. I did not do step (7) as I don't understand the underlined portion. Then make column...
Hi Amy I am getting a little confused. I am looking for a macro to delete out any rows with an error in column “ Then I want it to place a “0...
Good morning Amy!! That is quite a long list. Sometimes it is best to describe your objective instead of showing the steps you intend to get the...
No problem
Hi rathanak Refer my attachment. From your post I believe you are using the US date format. I am using the UK date format. The formulas are ...