View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Sandy-V Sandy-V is offline
external usenet poster
 
Posts: 1
Default Auto_Open disabling

Tom,

The "range of oddities" I've experienced with Excel &
Shift fall into these "opposite" categories:
Detection of shift when shift not pressed
Failure to detect a shift press

I can relate to the OP's initial suspicion of add-in's. I
also found that removing a certain add-in seemed
temporarily to cure the problem. However I doubt that is
the route cause, at least not directly.

Besides use of Shift in shortcuts to macros, as in the MS
KB article you referred to, a contributory cause might be
Windows shortcuts with Shift to xl files.

Regards,
Sandy

PS Above mainly XL97 but on rare intermittent occasions
experienced similar in XL2000


-----Original Message-----
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
.



.