Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How do I add a string to enable the "SORT" function in the following
workbook? My current string in the spreadsheet is as follows: Private Sub Workbook_Open() Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets(Array("Key Controls", "NonKey Controls")) With ws .Protect Password:="sox2005", DrawingObjects:=True, _ contents:=True, Scenarios:=True, _ userinterfaceonly:=True .EnableAutoFilter = True .EnableOutlining = True End With Next ws End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel crashes on "Close" Visual Basic error 400 | Excel Discussion (Misc queries) | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
visual basic example of the defunct "Extract" function in Excel 4. | Excel Programming | |||
Registry key for "Trust access to Visual Basic project" | Excel Programming | |||
How to set equivalent of Visual Basic "redraw = false" | Excel Programming |