Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Open workbook at a particular sheet
Hi all.
I have following code in a workbook, it protects all sheets, and turns on autofilter. (Excel 200). Private Sub Workbook_Open() On Error Resume Next Dim ws As Worksheet 'check for filter, turn on if none exists For Each ws In ActiveWorkbook.Worksheets With ws If Not .AutoFilterMode Then .Range("").AutoFilter End If .EnableAutoFilter = True .Protect Password:="", _ Contents:=True, UserInterfaceOnly:=True End With Next End Sub Can I add to this, to always open the workbook at a particular worksheet, regardless of where it was last closed (saved)? Any help with this code much appreciated. Many thanks George Gee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |