Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / July 2005



Tip: Looking for answers? Try searching our database.

Window hiding behind the toolbars

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kevs - 22 Jul 2005 04:52 GMT
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 - 22 Jul 2005 14:43 GMT
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?

On 7/21/05 11:52 PM, in article BF05BB76.DDF7%studiok4485@hotmail.com,

> 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.
[quoted text clipped - 4 lines]
> OS 10.4.2
> Office 2004

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

kevs - 23 Jul 2005 04:16 GMT
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.

On 7/22/05 6:43 AM, in article BF06704E.4AA44%bob@nospam.com, "Bob
Greenblatt" <bob@nospam.com> wrote:

> 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
[quoted text clipped - 10 lines]
>> OS 10.4.2
>> Office 2004

OS 10.4.2
Office 2004
kevs - 23 Jul 2005 04:20 GMT
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.

On 7/22/05 6:43 AM, in article BF06704E.4AA44%bob@nospam.com, "Bob
Greenblatt" <bob@nospam.com> wrote:

> 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
[quoted text clipped - 10 lines]
>> OS 10.4.2
>> Office 2004

OS 10.4.2
Office 2004
Bob Greenblatt - 25 Jul 2005 14:39 GMT
By being docked, I mean do they "snap" into position.

On 7/22/05 11:20 PM, in article BF07058F.DE94%studiok4485@hotmail.com,

> Bob:
> I mean you can move the toolbars around if you want. So maybe I'm not sure
[quoted text clipped - 20 lines]
> OS 10.4.2
> Office 2004

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

JE McGimpsey - 25 Jul 2005 18:04 GMT
> 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 - 25 Jul 2005 19:19 GMT
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

On 7/25/05 10:04 AM, in article
jemcgimpsey-CFFEC3.11040525072005@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:

>> 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

OS 10.4.2
Office 2004
JE McGimpsey - 26 Jul 2005 21:46 GMT
> 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 - 27 Jul 2005 05:38 GMT
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?

On 7/26/05 1:46 PM, in article
jemcgimpsey-FF1E9D.14460326072005@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:

>> Is that script available for download?
>
[quoted text clipped - 18 lines]
> 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 - 27 Jul 2005 05:43 GMT
I did the lock_toolbars.xla on desktop.  Where do I put It? Thanks!!!!!!!!!!

On 7/26/05 9:38 PM, in article BF0C5DF1.E02E%studiok4485@hotmail.com, "kevs"
<studiok4485@hotmail.com> wrote:

> JE:
> You know, my toolbars really seemed docked fine to be honest. So why these
[quoted text clipped - 29 lines]
> OS 10.4.2
> Office 2004

OS 10.4.2
Office 2004
JE McGimpsey - 27 Jul 2005 13:14 GMT
> 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 - 27 Jul 2005 13:17 GMT
> 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 - 28 Jul 2005 04:34 GMT
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.

On 7/27/05 5:17 AM, in article
jemcgimpsey-CF8F38.06174627072005@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:

>> You know, my toolbars really seemed docked fine to be honest. So why these
>> workbooks are jumping behind it, maybe it's something else?
[quoted text clipped - 7 lines]
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.