Row deletion and auto filter
Hi
How do you disallow row deletion, when auto filter is active? Rich |
Row deletion and auto filter
the question is more likely how to you allow autofiltering when the sheet is
protected. If the autofilter is already in place (the arrows are visible), you can then do with Worksheets("Sheet1") .EnableAutofilter=True .Protect Password:="ABCD",UserInterfaceOnly:=True End With This will allow the arrows to be used to filter the data while protection remains. You need to run this code whenever the workbook is opened or you are going to apply protection. The userinterfaceonly property can only be set in code. You might want to use the Workbook_Open event to run the code. See Chip Pearson's overview of events if you are not familiar with them http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "RMJames" wrote: Hi How do you disallow row deletion, when auto filter is active? Rich |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com