workbook_open() & workbook_beforeclose()

[Fwiz]

i'm tryin to add in this 2 vba codes - the first to workbook open event and the second is to workbook before close event

Sub workbook_open()
Dim Ctrl As Office.CommandBarControl
For Each Ctrl In Application.CommandBars.FindControls(ID:=522)
Ctrl.Enabled = False
Next Ctrl
End Sub

Sub workbook_beforeclose()
Dim Ctrl As Office.CommandBarControl
For Each Ctrl In Application.CommandBars.FindControls(ID:=522)
Ctrl.Enabled = True
Next Ctrl
End Sub

i can't seem to make the vba code work correctly when opening and closing the workbook.
- am i missing something?

 

[Fwiz]

Any Suggestions??

thanks for your help

 

[milesUK]

Fwiz, Have you placed the code in the "ThisWorkbook" object area? Given that the workbook_open() has no capitals I suspect not.

 

[al_b_cnu]

Fwiz, Have you placed the code in the "ThisWorkbook" object area? Given that the workbook_open() has no capitals I suspect not.

dont know if it's relevant, but I noticed that the Before_close doesnt have the 'Cancel As Boolean' parameter

 

[Fwiz]

ahhhh see, newby mistakes!!!
i've added this to the workbook module area and added cancel as boolean....all sorted

thanks for your input guys!!