| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using VBA to Protect sheet(s) with Autofilter
Seems like this was working (In "Thisworkbook"): Sub workbook_Open() Sheet1.EnableAutoFilter = True Sheet1.Protect userinterfaceonly:=True Sheet2.EnableAutoFilter = True Sheet2.Protect userinterfaceonly:=True Protect Password:="pass" End Sub Even if I renamed the sheets I still have to use "Sheet1, Sheet2" etc as commands Phoenix : ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Utilizng full AutoFilter features while specific cells are protect | Excel Discussion (Misc queries) | |||
| Utilizng full AutoFilter features while specific cells are protect | Excel Worksheet Functions | |||
| Utilizng full AutoFilter features while specific cells are protect | Excel Discussion (Misc queries) | |||
| How to protect formula's, but allow autofilter | Excel Worksheet Functions | |||
| how do i protect an Autofilter funtion on Excel 2000 | Excel Worksheet Functions | |||
Threaded Mode
