Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error
Thank you. This works when I step through it, but I get a
run time error every time I click the togglebutton on the sheet. Unable to set hidden property of range class Any ideas how to get around this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error
Go back to your original post and ask there.
-- Don Guillett SalesAid Software "REGINALD BAST" wrote in message ... Thank you. This works when I step through it, but I get a run time error every time I click the togglebutton on the sheet. Unable to set hidden property of range class Any ideas how to get around this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
run time error
Thank you. This works when I step through it, but I get a
run time error every time I click the togglebutton on the sheet. Unable to set hidden property of range class Any ideas how to get around this? do you work with Excel97? Then activate the active selection before run the VBA Code: Private Sub ToggleButton1_Click() Selection.Activate Rows.Hidden = False If ToggleButton1.Value Then Rows("1:4").Hidden = True Rows("15:65536").Hidden = True End If End Sub -- Regards Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |