View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Auto_Open disabling

http://support.microsoft.com/?kbid=175223
XL97: Visual Basic Procedure Halts on Workbooks.Open

But that stops macros - kind of the opposite of the stated problem.

Regards,
Tom Ogilvy

Sandy-V wrote in message
...
I posted a semi related question in July 02, subject:
"Add-in startup problem using keyboard shortcuts"

Dave Peterson pointed me to this thread and a comment by
Myrna Larson

http://groups.google.com/groups?
threadm=u7ufks038r9jjaaa3jrt2c3cpilu7rshja%404ax.c om

At the time I blamed an add-in, in hindsight unfairly, in
rather the same way you just have. Since then I have
encountered a range of oddities with Excel and Shift.

Regards,
Sandy

-----Original Message-----
I was always under the impression that holding down the
SHIFT key while opening a workbook disabled the automatic
processing of the Auto_Open Macro. Are there other
settings that would cause this functionalilty not to

occur
that I am not aware of with office 2000? Suddenly my
project ALWAYS executes the Auto_Open macro even while
holding down the SHIFT key.

Thanks,
Tritan
.