Toolbar question

[nickra]

Mt toolbars float above my worksheet and are detached. How do I attach
them to clean up my screen a bit. I''d like to lock them into position
and have them open this way.

 

[PhilD]

Mt toolbars float above my worksheet and are detached. How do I attach
them to clean up my screen a bit. I''d like to lock them into position
and have them open this way.

If I've understood you correctly, just drag the toolbars to where you
want them. If you put them just under the, umm, what's it called?,
the bar at the top that has the application name and various menus,
and to the left, then theyshould "pop" into place, and the worksheet
will maximise without interfering with them.

PhilD

 

[JE McGimpsey]

If I've understood you correctly, just drag the toolbars to where you
want them. If you put them just under the, umm, what's it called?,
the bar at the top that has the application name and various menus,
and to the left, then theyshould "pop" into place, and the worksheet
will maximise without interfering with them.

And if you want to lock them in place:

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

 

[nickra]

And if you want to lock them in place:

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

The pop into place with the toolbar up top but do not lock with the
worksheet. I hate dragging the stuff around on the screen. My toolbars
are sometimes half the length of the worksheet and unlocked. How can I
rectify this. I don't recall this being an issue in Excel for Windows.

 

[JE McGimpsey]

And if you want to lock them in place:

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

The pop into place with the toolbar up top but do not lock with the
worksheet. I hate dragging the stuff around on the screen. My toolbars
are sometimes half the length of the worksheet and unlocked. How can I
rectify this. I don't recall this being an issue in Excel for Windows.[/QUOTE]

Did you place the code in the places specified? What happens when you
run the Workbook_Open code manually?

 

[nickra]

Did you place the code in the places specified? What happens when you
run the Workbook_Open code manually?

I have to mass around with code to do this? Isn't this like a pretty
basic function/look for a spreadsheet/Excel? Did Mac do this
deliberately on their version of Excel? Why would they do that?

 

[JE McGimpsey]

I have to mass around with code to do this? Isn't this like a pretty
basic function/look for a spreadsheet/Excel? Did Mac do this
deliberately on their version of Excel? Why would they do that?

No version of Office, Win or Mac, allows users to lock toolbars in place
without using code. So no, it's not a pretty basic function.

 

[CyberTaz]

John's macro was offered as an option, not as a necessity

If you drag the toolbars to the edge of the screen [beyond the edge of the
sheet] the sheet will adjust out of the way & the bars will remain there
until you move them again - even when you restart the program. You can dock
vertical bars side-by-side as well as dock their top edges to the bottom
edge of toolbars docked at the top (bottom edge of the menu bar).

The Windows OS & Mac OS differ in that there is no "application window" on
the Mac such as there is on the PC, so Yes the toolbars behave a bit
differently. The difference isn't that significant.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/7/07 11:57 PM, in article
(e-mail address removed), "nickra"

Did you place the code in the places specified? What happens when you
run the Workbook_Open code manually?

I have to mass around with code to do this? Isn't this like a pretty
basic function/look for a spreadsheet/Excel? Did Mac do this
deliberately on their version of Excel? Why would they do that?

 

[nickra]

John's macro was offered as an option, not as a necessity

If you drag the toolbars to the edge of the screen [beyond the edge of the
sheet] the sheet will adjust out of the way & the bars will remain there
until you move them again - even when you restart the program. You can dock
vertical bars side-by-side as well as dock their top edges to the bottom
edge of toolbars docked at the top (bottom edge of the menu bar).

The Windows OS & Mac OS differ in that there is no "application window" on
the Mac such as there is on the PC, so Yes the toolbars behave a bit
differently. The difference isn't that significant.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 10/7/07 11:57 PM, in article
(e-mail address removed), "nickra"

I have to mass around with code to do this? Isn't this like a pretty
basic function/look for a spreadsheet/Excel? Did Mac do this
deliberately on their version of Excel? Why would they do that?

So, bottom line: Without a macro, I cannot make my Mac Excel toolbars
behave the same way as I can in my Windows laptop? Just curious: Why
would the software designers do this? I can't image, if you could poll
all Excel users, that anywhere close to a majority would want this, at
least not without the option to lock it all together.

 

[JE McGimpsey]

So, bottom line: Without a macro, I cannot make my Mac Excel toolbars
behave the same way as I can in my Windows laptop? Just curious: Why
would the software designers do this? I can't image, if you could poll
all Excel users, that anywhere close to a majority would want this, at
least not without the option to lock it all together.

That's not what I (or Bob) wrote at all. I wrote that to lock toolbars
in place, one has to use code. That is true whether you're using WinXL
or MacXL. So the answer to your first question is that your assertion is
incorrect. Bottom line. That makes your second question moot.

But since Windows and Mac OS's handle applications differently, of
course there will be differences between the platforms in how the system
and application interact.

The toolbars will dock in MacXL. Without macros. They just tend to be
more susceptible to being undocked than the toolbars in WinXL seem to
be. That *may* be MS's "fault", or it may be related to how Mac OS
handles window events, or perhaps something else entirely. Macros won't
change this behavior.