I'm just getting back to VBA for Excel, and I am now using Excel
2007. One thing in the VBA studio bothers me. The Intellisense
window sometimes does not pop-up. Usually, it fails to pop up after
the second level. For example, if I want to activate the first sheet
in the first book, I type "Workbooks(1).WorkSheets(1)". The
intellisense window does not come up to give me the properties and
methods exposed by the Worksheet. Can I change this?

Oddly, if I type "Dim s as Excel.Worksheet", then typing "s" will give
me the intellisense window that I want.