Dear Forum members,
I would like to add VBA code to my file which on open activates, and sets the Excel Autofilter (just the normal basic filter with arrows)on the same entire row.
The story behind is that we have a shared Excel file in our group, and sometimes other users deactivate the filter and save...or move to other rows and then save etc.
It would be nice to have the workbook on open, always filter enabled on the entire row.
So basically:
onOpen
Set Autofilter row 10.
Thank you.
I would like to add VBA code to my file which on open activates, and sets the Excel Autofilter (just the normal basic filter with arrows)on the same entire row.
The story behind is that we have a shared Excel file in our group, and sometimes other users deactivate the filter and save...or move to other rows and then save etc.
It would be nice to have the workbook on open, always filter enabled on the entire row.
So basically:
onOpen
Set Autofilter row 10.
Thank you.