I'm using Excel 2013. The VBA reference is part of Excel (built-in) so I can't remove it.
Is it possible to reference another version of the VBA library? The reason I want to know other than curiosity is to look at the object browser of the older versions to see if it lists some currently-hidden/obsolete properties/methods such as Excel.DialogSheet.
The Workbook.SheetActivate event has a Sh
parameter of type Object. One of the possible sheet types is Excel.DialogSheet
which should be checked with the TypeOf operator.
When I try to add another VBA reference I get the message: Name conflicts with existing module, project, or object library
.
The default one being used is from:
The other references available are from:
I also checked another computer with Excel 2003 that uses:
And has:
Simple answer is no. Also, there is no need to. Just open the Object Browser, right-click something and choose 'Show hidden members'. You can then browse all the deprecated features like DialogSheet
to your heart's content. :)