Disable entry if autofilter is on

Maybe:

Please Login or Register  to view this content.

john that doesnt seem to do anything?

do i need to put something into the "" after target.value?

The code goes into the specific Sheet Event Module. The user won't be able to make an entry if the Filters are on. I thought that was what you wanted. The code worked when I tested it.

I can't duplicate your errors from your sample. For the msgbox. Goes in the ThisWorkbook - Workbook - Workbook_SheetChange Event

Please Login or Register  to view this content.

great - i get no errors there - the user still can technically enter text though, despite the warning.

I was wondering if there was a way that if the filter was on, the range below the filtered content (call it A (whatever the last filtered row was) to A:195) to be locked so that nothing could be entered, and then when the filter is removed the locked cells would all be too...

does my last reply make sense, so that the rows immediately after the filtered content up to and including row 195 are locked so noone can enter any data there (and maybe a msgbox pop up saying so) and then the only way to unlock that range is to unfilter?

It's doable. However, it would involve passwords, and protecting the sheet? A bit more complicated. I was trying to find a work around. I don't think you'd want each user to have a password? Wouldn't that defeat the purpose?

could u not have the password inbuilt into the macro, so that the autofilter being ON turns the lock state (and password) on, and undoing the filter turns the Lock state and password off?

Maybe you can experiment with this to get the desired result.

Please Login or Register  to view this content.

again that doesnt seem to do anything, is the protection on properly in that code? I am placing this in YourWorkbook...

any ideas?

hi nickmax1, please check attachment, try to add value in row 23 and remove filter. It does not use any VB

watersev,
I dont understand, I am perfectly able to edit row 23 with filters on?

maybe I got you wrong, what is the problem if you enter data in row 23 and remove filter on B column?

there is no problem - which is the problem!!
if there is an autofilter applied the user should NOT be able to edit any rows below the filtered range...only when the autofilter is deselected should the user be able to do so.

try this out

ooh that is clever....

How do i get this to work in my ThisWorkbook so that it runs on any sheet?

please check attachment

watersev that works brilliantly,

how do i merge that with my current event_change?

Please Login or Register  to view this content.