Help to get out of draw mode!?1

[StargateFanFromWork]

Good Morning! Well, I've never done this before. Went to archives and
can't seem to find help to the particular problem I just backed myself into
<g>. I had an icon on my toolbar that I accidentally pressed. It was for
draw mode, I believe. In one fell swoop I lost all my regular pulldowns
plus my custom icons. Since I'd just made other changes this morning, don't
have a recent enough version of my XLB file so I'm stuck! Can someone pls
tell me how to get out of this mode pls? Old Mr. Genius was no help
either!! <lol>

Thanks! D

(Hope this msg gets through. I've been having difficulty in last few days.)

 

[CLR]

View > Toolbars > uncheck the Drawing toolbar selection
Maybe there too you will see some of your regular or special toolbars that
are "unchecked" now for some reason.


Vaya con Dios,
Chuck, CABGx3

 

[StargateFanFromWork]

Well, um, that's the thing ... no pulldowns, no menus, nothing. Pressing
Alt and various combinations of letters, function keys doesn't do a darn
thing, either! <g> Help!

I only have the formula bar and the column and row numbers and letters.
I've never had this happen before! D

 

[StargateFanFromWork]

Well, um, that's the thing ... no pulldowns, no menus, nothing. Pressing
Alt and various combinations of letters, function keys doesn't do a darn
thing, either! <g> Help!

Okay, just figured out what happened. It's not the icon that did it, it's
the code I had attached to that icon. This is so silly. I believed the
code to be what I needed for fixing floating toolbars that stay open as I've
learned to remove the "X" from the upper right-hand corner. But that's not
the case. The code disables ALL toolbars and menus. So obviously, it's
overkill <g>.

I was assuming that the original icon was doing this, the one the I assigned
the macro to (which happened to be the draw one). Will have to post a new
msg to get myself out of this pickle without losing my original xlb file!
<g> Okay, haven't done something downright stupid in a while. I was due
for one <g>.

Thanks! D

 

[CLR]

Glad you got it unscrambled, and thanks for letting us know.....

Vaya con Dios,
Chuck, CABGx3

 

[StargateFanFromWork]

Glad you got it unscrambled, and thanks for letting us know.....

<g> Yup, took some doing but I managed to figure out what happened. I got
the default/generic toolbars back by renaming my xlb file. I ended up
re-writing the code that closed all my toolbars by just setting them "true"
and put that in an Auto_Open macro in my still accessible personal.xls. I
closed XL2K and renamed my xlb file back. When I re-opened XL2K, the
Auto_Open macro made toolbars visible again. Went back and deleted all
these open/close toolbars lines of code!

I didn't realize that the code I'd inadvertently launched would disable
_all_ toolbars and menus. It used the term "commandbars" which I only just
saw in last few days as I'd learned to make floating toolbars. But it seems
that this is the term for _all_ toolbars/menus. So that idea of having code
for closing orphan floating toolbars will wait for another day. I obviously
need to learn more before tackling that problem (you see, I've learned how
to take the "X" out of the titlebar of my floating toolbars but that can
leave orphan toolbars if I edit them in a certain way. Was originally
looking for something that would allow me to easily close those orphan ones
without the massive editing the hard way ... but not _all_ my toolbars).

All this so that if some other newbie accidentally does something similar,
they have a workaround. In a thread in the excel programming group, a kind
poster gave an alternative that is through the vbe. At least we have a
couple of ways now.

Thanks.

Cheers! D