Hello

i have an excel summary workbook with buttons that open existing workbooks (each button open a different workbook)
[VBA]
Application.Workbooks.Open ('path')
ActiveSheet.Range("$A$1:$B$6").AutoFilter Field:=1, Criteria1:=Proj_select
[/VBA]

after the workbook opened i want that the user won't be allowed to change the filter and save the workbook.
the only option will be save as and after he confirm the save the workbook will close without saving the filter.

thanks