-
prevent your from changing filter
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules