Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error '1004'
Greetings All,
I am getting a run time error '1004' (select method of range class failed) only when I click on a hyperlink in the sheet. Thanks in advance. --Sam K. Public Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) With Application .ScreenUpdating = False .EnableEvents = False ActiveSheet.unprotect Windows(1).VisibleRange.WrapText = True ' wrapping text only in the visible range window Target.Select .EnableEvents = True .ScreenUpdating = True ActiveSheet.protect End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error '1004' | Excel Worksheet Functions | |||
run time error 1004 | Excel Discussion (Misc queries) | |||
run time error 1004 | Excel Discussion (Misc queries) | |||
Run Time Error '1004' | Excel Worksheet Functions | |||
Run time error 1004, General ODBC error | New Users to Excel |