i used a "clean" workbook and it worked...

will have a look and play around

much appreciated!!!!

thanx

Phillip

"Matthew Pfluger" wrote:

Hmm, not sure why that is. Can you try this ultra-simple macro below? With
those two security settings checked, you shouldn't have any problems with
this. Otherwise, I'm not sure.

Sub test()
Application.VBE.ActiveCodePane.Show
End Sub

Matthew Pfluger