Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to hide a toolbar called "Abuse" when the workbook closes. I
looked it up in Walkenbach and tried to modify the code I found there for my purpose. It doesn't work, but it doesn't hang either. Surprising that it doesn't hang up. Here is the code from the Class Module "HideToolbar" Public WithEvents AppEvents As Application Private Sub appevents_beforeclose() Application.CommandBars("Abuse").Visible = False End Sub Here is the code from "ThisWorkbook": Private Sub BeforeClose() Call Init End Sub Here's the code from the regular module: Dim AppObject As New HideToolbar Sub Init() Set AppObject.AppEvents = Application End Sub Any ideas on why it doesn't hide the toolbar? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
class module? | Excel Programming | |||
let and get in class module | Excel Programming | |||
Class Module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |