Disabling the Advanced filter function

Hello ngk08,

The Advanced Filter menu can be disabled just like any other menu item using VBA. The following statement will disable that entry:

Please Login or Register  to view this content.

Remember to reset it back to True before saving and/or closing the workbook so it is available on other worksheets.

Code like the following will unprotect the sheet, disable the Advanced Filter option, then re-protect the sheet:

Please Login or Register  to view this content.

You could put that code into the worksheet's code module that you want protected. (Right-click on that sheet's tab and choose View Code, then paste this code into the white window and close the VB Editor. You can then run the macro by pressing ALT+F8 and selecting 'disableAdvFilter' and clicking Run.)

The following code would re-activate the Advanced Filter menu option, and could be placed in the ThisWorkbook module. In the VB Editor (press ALT+F11 to get there), double-click on the 'ThisWorkbook' entry in the left-hand column, then paste this code:

Please Login or Register  to view this content.

Coltrabagar,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.