If you declare a Worksheet object and set an object reference to the
sheet, you should get the dropdown after you press "."

For example:

Dim mysht As Excel.Worksheet
Set mysht = Worksheets("Sheet1")
mysht.


HTH,
JP

On Apr 26, 9:02*pm, David_G wrote:
Can anyone assist? *I have a problem with Auto List Members, in
particular how reliably they appear or not appear. *I often use
Sheets("mySheet"). *when I enter the "dot" there is no Auto List
produced. *How come?
Similarly, I am currently working with commandbars, in particular the
code below: