ADAMC
Well-known Member
- Joined
- Mar 20, 2007
- Messages
- 1,169
- Office Version
- 2013
- Platform
- Windows
Hello all, thanks in advance for your input:
Is there a macro or can anyone point me in the right direction as to finding a list of all excel events such as Workbook_Open Workbook_Close etc etc. Is there a macro which coud list these?
Also looking to find a list of all properties within commands:
For example: When i type 'thisworkbook. it autoshows me all the available commands within that type. IE thisworkbook.activate etc.
Anyway to pull all these from Excel with a macro or does anyone know any good resources?
I am attempting to put together some sort of index on event types etc, can get most of my help from the help menu but just thought there may be some code to grab details.
Edit**
Sorry guys, just realised i can obviously use the Object browser and was getting ahead og myself...Would still be interested if anyone has a macro or such like though, thanks!
Thanks
Is there a macro or can anyone point me in the right direction as to finding a list of all excel events such as Workbook_Open Workbook_Close etc etc. Is there a macro which coud list these?
Also looking to find a list of all properties within commands:
For example: When i type 'thisworkbook. it autoshows me all the available commands within that type. IE thisworkbook.activate etc.
Anyway to pull all these from Excel with a macro or does anyone know any good resources?
I am attempting to put together some sort of index on event types etc, can get most of my help from the help menu but just thought there may be some code to grab details.
Edit**
Sorry guys, just realised i can obviously use the Object browser and was getting ahead og myself...Would still be interested if anyone has a macro or such like though, thanks!
Thanks