Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Code
If I protect my vba code the workbook_Open functions do not work. Neither
does Before_Close() functions. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Code
What is the code in your subs? I've never encountered that problem
before. Mike H. wrote: If I protect my vba code the workbook_Open functions do not work. Neither does Before_Close() functions. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect Code
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'this builds the menus that are added when this workbook is loaded Application.CommandBars("Worksheet Menu Bar").Controls("&Activity").Delete End Sub Private Sub Workbook_Open() Dim Menu1 As CommandBarControl Dim MainMenuBar As CommandBar Dim CustomMenu As CommandBarControl On Error Resume Next Application.CommandBars("Worksheet Menu Bar").Controls("&Activity").Delete On Error GoTo 0 Set MainMenuBar = Application.CommandBars("Worksheet Menu Bar") HelpMenu = MainMenuBar.Controls("Help").Index Set CustomMenu = MainMenuBar.Controls.Add(Type:=msoControlPopup, Befo=HelpMenu) CustomMenu.Caption = "&Activity" With CustomMenu.Controls.Add(Type:=msoControlButton) .Caption = "Assign xxxxx" .OnAction = "CategorizeNewInventory" End With '....etc..... End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
Generic protect/unprotect code through buttons and code? | Excel Programming | |||
What is the best way to protect VBA code | Excel Programming | |||
Protect Code | Excel Programming |