View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default ctrl+break when modeless

hold the shift key as you launch excel and see if that works. else

start excel in safe mode. add /s to the end of the shortcut that starts excel
and then change it back when you're done

--


Gary


"hughie" wrote in message
ps.com...

hughie wrote:

Mike wrote:

Access the code by using the VB editor (Tools - Macro - VB Editor). If the
userform hasn't terminated its a good idea to do this first


When I terminate the userform it closes the whole spreadsheet therefore
I can't get to the editor that way unfortunately. I can open the
editor when I start excel without opening any specific spreadsheet but
then my code is, of course, unavailable as I don't have my xls open.
See what I mean?

This has GOT to be an easy one.... I thought....hehe


the version of the code i was using before, the one that was running
the form modally, was doing an 'application.visible = false', so users
only see the form. Although there is a way to get to were I want by
taking that version forward, I'm now curious to know if there is a way
to get to the code in this situation.

Just to clarify, I can't get to the editor, or the spreadsheet and
ctrl+break is no longer available. The previous suggestions are
welcome but off the mark.

curious..


H !?