Hello everybody,
do someone has an idea how i can use a macro for restting/removing filter but not affecting other views?
Currently i have a secured excel-file and a macro (button) which resets the filter. Problem is, that this macro affects everybody views a resets the filter for everybody collaborating in the file.
Is there any solution for that?
Macro:
Sub Filter()
Application.ScreenUpdating = False
Sheets("Terminsteuerung").Select
ActiveWindow.FreezePanes = False
Range("T_Terminsteuerung[#Headers]").Select
Selection.AutoFilter
Selection.AutoFilter
Range("L48").Select
ActiveWindow.FreezePanes = True
Range("T_Terminsteuerung[[#Headers],[Bauvorhaben]]").Select
Application.ScreenUpdating = True
End Sub
Thank you in advance
Bookmarks