Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
JE McGimpsey wrote:
In any case, here's the correct code in my DimButtonClass module: Public WithEvents DBApp As Application Private Sub DBApp_WorkbookDeactivate(ByVal Wb As Excel.Workbook) On Error Resume Next CommandBars.FindControl(Tag:=csCTRLTAG).Enabled = _ (Workbooks.Count 1) On Error GoTo 0 End Sub Private Sub DBApp_WorkbookOpen(ByVal Wb As Excel.Workbook) On Error Resume Next CommandBars.FindControl(Tag:=csCTRLTAG).Enabled = True On Error GoTo 0 End Sub Again, sorry for my mix-up. Now it's working great! Thanks! -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable the save button | Excel Discussion (Misc queries) | |||
Disable X button on excel | Excel Worksheet Functions | |||
Disable Close Button | Excel Discussion (Misc queries) | |||
How do you disable the Collate button? | Excel Discussion (Misc queries) | |||
Disable Button | Excel Programming |