Counting Objects on a worksheet ....

[chander]

i hv got one problem with OLEObjects if any of u guy can help me out ..
I got some Some OLEObjects and/or Embedded objects in my workbook/sheet . I want to know its count and if there is even one object like form control , OLE object , embedded control , class/DLL library etc. i want to take some action.I am checking this by Putting a msgbox in Workbook_Open like

Msgbox Activeworkbook.Worksheets("Sheet1").OLEObjects.Count

and i put a command buttong and List box on Sheet and open workbook ..

The workbook_open event never gets fire when i open the workbook ... Not only Workbook_open event , even no event after tht gets fire... how i can come to know while opening my work book tht it has Form control or any other object in it so that i can take my action ...

 

[Juan Pablo González]

Put this in the inmediate pane in VBE

Application.EnableEvents = True

 

[chander]

humm i did but it hink problem was some where else .. my security setting on tht workbook was high and maros were disabled so code was not running ... its working now ...