i have this code to run autofilter in protected sheet2, assigned to a check Box,
but it gives me this Msg when i run the code by checking the check Box :
File in use
The file is locked for editing by the (my name)
Any idea why is this ?
However, when i excute the code by F5 in the VBE window, it works fine
also when i excute the code from Worksheet_Activate , it works fine
here is the code: