Getting a Microsoft Word icon in Excel custom toolbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bartmv - 23 Dec 2005 14:40 GMT

For ease of switching between the two applications, I have inserted the
Microsoft Excel icon onto my MS Word toolbar (using View / Toolbars /
Customize Toolbars / Menus).

I can not seem to locate the same functionality in MS Excel -- I can
not find a Microsft Word icon anywhere in the list of commands.

Is it missing?

Reply to this Message

JE McGimpsey - 23 Dec 2005 15:43 GMT

> For ease of switching between the two applications, I have inserted the
> Microsoft Excel icon onto my MS Word toolbar (using View / Toolbars /
[quoted text clipped - 4 lines]
>
> Is it missing?

There's no comparable built-in command in XL. However, it's very easy to
implement.

Put this macro in your Personal Macro Workbook (or another add-in),

Public Sub SwitchToWord()
Dim oWordApp As Object
On Error Resume Next
Set oWordApp = GetObject(, "Word.Application")
If oWordApp Is Nothing Then
Set oWordApp = CreateObject("Word.Application")
oWordApp.Documents.Add
End If
On Error GoTo 0
AppActivate "Microsoft Word"
Set oWordApp = Nothing
End Sub

Now insert a Custom Button on your desired toolbar, and attach the macro
to the button.

Reply to this Message

Mac Forum / Applications / Excel / December 2005

Getting a Microsoft Word icon in Excel custom toolbar