Attn: Jim Gordon Menubars

A

Alan Marcelius

Application.Commandbars("testbar").Protection = msoBarNoMove
Click to expand...

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).


Any other suggestions? Thanks

Alan
 
J

Jim Gordon

Hi again,

Be sure you have installed at least the 10.1.2 update for office.
It's here:
<http://www.microsoft.com/mac/downloads.aspx?pid=download&location=/mac/DOWN
LOAD/OFFICEX/OfficeX_1012.xml&secid=5&ssid=11&flgnosysreq=True>

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------
Application.Commandbars("testbar").Protection = msoBarNoMove
Click to expand...

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).


Any other suggestions? Thanks

Alan
Click to expand...
 
A

Alan Marcelius

Hi again,

Be sure you have installed at least the 10.1.2 update for office.
It's here:
<http://www.microsoft.com/mac/downloads.aspx?pid=download&location=/mac/DOWN
LOAD/OFFICEX/OfficeX_1012.xml&secid=5&ssid=11&flgnosysreq=True>
-Jim Gordon Alan Marcelius
<[email protected]> wrote:
Click to expand...
[re sticking toolbars & view windows]

I renamed my Office folder 10.1.3, as a way to remember which upgrades I've
applied, but for some reason don't see the actual upgrade program 10.1.3 in
my saved downloads file for emergencies. Boy, it'd be great for the MS
updates to do that for us since each application has its own version.

[it'd be nice to have a record in the ~ library - "receipts", even tho' you
can't use them for recovering file updates].

I would like to upgrade further, but it'd take hours with a modem, and I
don't use a server.

Also, how do I delete the VBA routine I put in to lock the custom toolbar.
Browsing under VBA didn't lead me to the routine.
 
A

Alan Marcelius

Application.Commandbars("testbar").Protection = msoBarNoMove
Click to expand...

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).


Any other suggestions? Thanks

Alan
Click to expand...
I may have misdirected another interim post, so I'll recopy to here. By the
way, does "reply to sender" not go into the newsgroup as does "reply to
newsgroup"? Or should we click on the original message quoted. I've been a
bit confused as to the distinctions. Thanks, Alan


Application.Commandbars("testbar").Protection = msoBarNoMove
Click to expand...

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).


Any other suggestions? Thanks

Alan
 
J

Jim Gordon

Hi

"Reply to sender" should send a message to the email address of whomever
posted a message.

"Reply to Newsgroup" should send a message to the newsgroup to be posted in
the same thread (assuming you don't change the subject).

You should be able to see your code in "Modules" folders using the Project
Explorer window within the visual basic editor (View > Project Explorer).

I'm not positive, but what you are describing concerning document windows
opening underneath your new toolbar arrangement may be simply normal
behavior. Documents remember the position of their windows based upon the
last time you saved the document. If you add a toolbar then open a
previously saved document, it will be underneath the toolbars. To fix this
simply reposition the document's window then save the document before you
close it. Next time it opens it should be where you left it.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------
Application.Commandbars("testbar").Protection = msoBarNoMove
Click to expand...

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).


Any other suggestions? Thanks

Alan
Click to expand...
I may have misdirected another interim post, so I'll recopy to here. By the
way, does "reply to sender" not go into the newsgroup as does "reply to
newsgroup"? Or should we click on the original message quoted. I've been a
bit confused as to the distinctions. Thanks, Alan


Application.Commandbars("testbar").Protection = msoBarNoMove
Click to expand...

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).


Any other suggestions? Thanks

Alan
Click to expand...
 
A

Alan Marcelius

Application.Commandbars("testbar").Protection = msoBarNoMove
Click to expand...

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).
Click to expand...
I'm not positive, but what you are describing concerning document windows
opening underneath your new toolbar arrangement may be simply normal
behavior. Documents remember the position of their windows based upon the
last time you saved the document. If you add a toolbar then open a
previously saved document, it will be underneath the toolbars. To fix this
simply reposition the document's window then save the document before you
close it. Next time it opens it should be where you left it.
Click to expand...

I'm not experiencing the behavior of the windows you described 'should'
happen consistently with all doc windows. And, the part of my message "[and
worse yet closing & error messages (are appearing underneath the custom
toolbar, which is 3 lines deep)]" also shows a deeper problem with custom
toolbars.

First, whenever I start Word, the "Document1" window always appears
underneath my custom toolbar unless I park lines of standard toolbars
underneath my custom toolbar. Second, whenever I start a new doc, it will
open underneath my custom toolbar. Third, whenever I open a document first
created with Word docked to the toolbars, if I open them, move the window to
a new position, and resave them (using "save as" and replacing the original
doc), those windows always open underneath the custom toolbar.

That simply is a Word X coding error.

The custom toolbars simply don't have the same characteristics of docking as
the standard toolbars do. Period. No excuses, now from the boys back at
the farm, please.
You should be able to see your code in "Modules" folders using the Project
Explorer window within the visual basic editor (View > Project Explorer).
Click to expand...

Sorry, but I'm a complete newbie to VBA, and even tho' I tried hard to save
the VBA file in the right place, I lost several of the files trying to make
the routine work. How can I find them in the finder window.
How is the default location set for these files?
Are they saved to the doc itself? Or available to all docs? Users?

Thanks again

Cheers, Alan
 
J

Jim Gordon

Hi

Take a peek at this web page concerning VBA:
Microsoft Excel for Macintosh
Visual Basic for Applications 101
http://support.microsoft.com/default.aspx?scid=/support/macexcel/content/Mac
VBA/MacVBA.asp

After updating to Office 10.1.2 and using Disk Utility to repair permissions
I stopped having problems with windows opening behind toolbars. Try creating
a new user in MacOS. If the new user does not experience the toolbar problem
you can be pretty sure that the preferences files are messed up in your
regular user. I suspect that if you have already installed the update that
the toolbar and office preferences should be deleted (with all office
applications off). You will lose any customizations you have made to the
toolbars if you do this, so you might want to copy those preference files
off to a removable storage device before you delete them in case you want
them back.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>

----------
Application.Commandbars("testbar").Protection = msoBarNoMove

Jim, somehow I finagled, by using a MS window under mine, so the new .doc
and file windows parked under the menubars without the above program. Then
I happened to customize again... And now the doc windows don't stick
anymore. The program you gave above did indeed make custom bar not move, but
docs [and worse yet closing & error messages] still go under it (it's a 3-
line bar).
Click to expand...
I'm not positive, but what you are describing concerning document windows
opening underneath your new toolbar arrangement may be simply normal
behavior. Documents remember the position of their windows based upon the
last time you saved the document. If you add a toolbar then open a
previously saved document, it will be underneath the toolbars. To fix this
simply reposition the document's window then save the document before you
close it. Next time it opens it should be where you left it.
Click to expand...

I'm not experiencing the behavior of the windows you described 'should'
happen consistently with all doc windows. And, the part of my message "[and
worse yet closing & error messages (are appearing underneath the custom
toolbar, which is 3 lines deep)]" also shows a deeper problem with custom
toolbars.

First, whenever I start Word, the "Document1" window always appears
underneath my custom toolbar unless I park lines of standard toolbars
underneath my custom toolbar. Second, whenever I start a new doc, it will
open underneath my custom toolbar. Third, whenever I open a document first
created with Word docked to the toolbars, if I open them, move the window to
a new position, and resave them (using "save as" and replacing the original
doc), those windows always open underneath the custom toolbar.

That simply is a Word X coding error.

The custom toolbars simply don't have the same characteristics of docking as
the standard toolbars do. Period. No excuses, now from the boys back at
the farm, please.
You should be able to see your code in "Modules" folders using the Project
Explorer window within the visual basic editor (View > Project Explorer).
Click to expand...

Sorry, but I'm a complete newbie to VBA, and even tho' I tried hard to save
the VBA file in the right place, I lost several of the files trying to make
the routine work. How can I find them in the finder window.
How is the default location set for these files?
Are they saved to the doc itself? Or available to all docs? Users?

Thanks again

Cheers, Alan
Click to expand...
 
Top