Window hiding behind the toolbars

[kevs]

My main workbook is constantly going behind the toolbar. I resize --hit
green button-- and it's ok for a few hours and then the problem repeats.
Happens in word too.

Kevs

OS 10.4.2
Office 2004

 

[Bob Greenblatt]

Are your toolbars Really docked? They may look docked, but are they really?
Try moving them up a bit. By any chance does this happen after a save or
autosave?

 

[kevs]

Thanks Bob:
They are docked good.
Does not happen after save or autosave.

I read something about this being a Tiger bug, in a Mac magazine, but did
not understand the fix.

Are your toolbars Really docked? They may look docked, but are they really?
Try moving them up a bit. By any chance does this happen after a save or
autosave?

OS 10.4.2
Office 2004

 

[kevs]

Bob:
I mean you can move the toolbars around if you want. So maybe I'm not sure
what you mean then by being docked.

Are your toolbars Really docked? They may look docked, but are they really?
Try moving them up a bit. By any chance does this happen after a save or
autosave?

OS 10.4.2
Office 2004

 

[Bob Greenblatt]

By being docked, I mean do they "snap" into position.

 

[JE McGimpsey]

By being docked, I mean do they "snap" into position.

You might also look here, for a way to make sure that those toolbars are
docked and can't become undocked:

http://www.mcgimpsey.com/macoffice/excel/locktoolbars.html

 

[kevs]

They do seemed docked pretty well and snap into place, and now, of course, I
can't replicate the problem consistently. But I'll keep an eye out on this,
was aware that docking was so important.

Thanks Bob:

JE:
Is that script available for download?

What does it do?

Is says you have to delete your toolbar preference?

Thanks

You might also look here, for a way to make sure that those toolbars are
docked and can't become undocked:

http://www.mcgimpsey.com/macoffice/excel/locktoolbars.html

OS 10.4.2
Office 2004

 

[JE McGimpsey]

Is that script available for download?

I didn't make it an add-in, though it would be easy enough. For a quick
and dirty job:

ftp://ftp.mcgimpsey.com/excel/lock_toolbars.xla

It will work fine, but it's not particularly friendly - it docks and
locks the Standard and Formula toolbars, but doesn't provide a method
for unlocking when the add-in's unloaded, nor does it do any error
checking.

What does it do?

It sets the Standard and Formula toolbar location to the top dock, then
prevents them from being modified.

Is says you have to delete your toolbar preference?

Toolbar prefs in XL are stored in that toolbar preference file. If you
have custom toolbars, deleting that file will get rid of them. Trashing
the file is not necessary, in any case.

 

[kevs]

JE:
You know, my toolbars really seemed docked fine to be honest. So why these
workbooks are jumping behind it, maybe it's something else?

I didn't make it an add-in, though it would be easy enough. For a quick
and dirty job:

ftp://ftp.mcgimpsey.com/excel/lock_toolbars.xla

It will work fine, but it's not particularly friendly - it docks and
locks the Standard and Formula toolbars, but doesn't provide a method
for unlocking when the add-in's unloaded, nor does it do any error
checking.


It sets the Standard and Formula toolbar location to the top dock, then
prevents them from being modified.


Toolbar prefs in XL are stored in that toolbar preference file. If you
have custom toolbars, deleting that file will get rid of them. Trashing
the file is not necessary, in any case.

OS 10.4.2
Office 2004

 

[kevs]

I did the lock_toolbars.xla on desktop. Where do I put It? Thanks!!!!!!!!!!

JE:
You know, my toolbars really seemed docked fine to be honest. So why these
workbooks are jumping behind it, maybe it's something else?








OS 10.4.2
Office 2004

OS 10.4.2
Office 2004

 

[JE McGimpsey]

I did the lock_toolbars.xla on desktop. Where do I put It? Thanks!!!!!!!!!!

Add-ins can be put anywhere. I put them in my MUD folder to keep them
safe and out-of-the-way, but MS's default location is

Microsoft Office 2004:Office:Add-ins:

If you put it in your

Microsoft Office 2004:Office:Startup:Excel:

folder, it will load automatically when you start XL.

 

[JE McGimpsey]

You know, my toolbars really seemed docked fine to be honest. So why these
workbooks are jumping behind it, maybe it's something else?

Dunno - are you switching monitor resolutions?

A bug in XL04 allows you to manually position workbooks behind the
toolbars - could that be what's happening? Repositioning the window,
saving, then quitting XL should solve that.

There have been other reports of windows positioning themselves behind
toolbars, but docking the toolbars has solved it for most people, AFAIK.

 

[kevs]

JE:
No, no switching anything--resolution wise.

I put the file in Excel , start up items, in apps folder.
Got this error:
"run time error 21447483640 (-7FFFFF8)
Method "position" of object "commandBar failed"

And the workbook that opens up with each launch now goes behind the tools
bars -- which look locked to me.

So this is a real beast here.

Dunno - are you switching monitor resolutions?

A bug in XL04 allows you to manually position workbooks behind the
toolbars - could that be what's happening? Repositioning the window,
saving, then quitting XL should solve that.

There have been other reports of windows positioning themselves behind
toolbars, but docking the toolbars has solved it for most people, AFAIK.

OS 10.4.2
Office 2004