I was using A2007 yesterday and today moved to 2010. And the same
feature, one I don't particularly care for, exists in both versions.

I have set the NavigationPane to be hidden when an app is opened. I
might have a command like
DoCmd.TransferSpreadsheet acLink, , "Junk", "C:\Junk.xlsx", True
in a routine. When the statement runs it is like saying "Open Sesame"
as the Navigation Pane gets opened and available for use and misuse
bythe user.

I decided to get clever and see if substituting acLink with acImport
would keep the the NavigationPane closed. That worked.

I explored further and created a link. Then I simply changed the
connection string to that table and that did not open the
NavigationPane.

So I do have a couple of alternatives towards keeping the
NavigationPane closed. But I would prefer simply using the
DoCmd.TransferSpreadsheet acLink option and still keep the
NavigationPane closed. Do you have a method that works?