tommy1234
03-31-2012, 05:37 AM
Hello
i have an excel summary workbook with buttons that open existing workbooks (each button open a different workbook)
Application.Workbooks.Open ('path')
ActiveSheet.Range("$A$1:$B$6").AutoFilter Field:=1, Criteria1:=Proj_select
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
i have an excel summary workbook with buttons that open existing workbooks (each button open a different workbook)
Application.Workbooks.Open ('path')
ActiveSheet.Range("$A$1:$B$6").AutoFilter Field:=1, Criteria1:=Proj_select
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