 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / October 2007Toolbar question
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. > 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 -- <>< > > 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 [quoted text clipped - 5 lines] > 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 > In article <1191221242.464181.313...@d55g2000hsg.googlegroups.com>, > [quoted text clipped - 11 lines] > > 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. > > And if you want to lock them in place: > > [quoted text clipped - 4 lines] > 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. Did you place the code in the places specified? What happens when you run the Workbook_Open code manually? > In article <1191296632.677987.174...@n39g2000hsh.googlegroups.com>, > [quoted text clipped - 9 lines] > 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? > 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. 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 1191815834.321415.316290@y42g2000hsy.googlegroups.com, "nickra" On Oct 2, 1:53 pm, JE McGimpsey <jemcgimp...@mvps.org> wrote: > In article <1191296632.677987.174...@n39g2000hsh.googlegroups.com>, > [quoted text clipped - 10 lines] > 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? > John's macro was offered as an option, not as a necessity:-) > [quoted text clipped - 37 lines] > 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. > 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. |
Reply to this Message |
 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
|
©2009 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.