close

The quot;Reviewingquot; toolbar keeps appearing on the desktop. I remove it and it
comes back up when I open Excel the next time. Is there any way to
permanently keep this toolbar from appearing on the desktop until it is
needed?

Joe

A recent posting from Jim Rech addresses this.Jim post..................

If the workbook is sent as an attachment to Outlook then File, Properties
are automatically added which will make the Reviewing toolbar appear when
the workbook is opened in Excel. I don't know of a way to stop this.

However, once you open the workbook in Excel you can remove these properties
and save the workbook. After that it will no longer cause the reviewing
toolbar to appear. Here's an old message on that:

--------------

The Reviewing toolbar in Excel pops up whenever you open a workbook that has
been emailed from within Excel quot;for reviewquot;. There may be other ways to
make this happen too. If you do a File, Properties you'll see the custom
file properties that have been added that triggers this.

You can kill the added file properties manually or run the below macro to do
it. This macro is in my Personal and attached to a toolbar button because I
feel the same way as you about this toolbar.

--
Jim Rech
Excel MVP

Sub KillReviewingCustProps()
Dim x As DocumentProperties
Dim Counter As Integer
Set x = ActiveWorkbook.CustomDocumentProperties
For Counter = x.Count To 1 Step -1
If Left(x.Item(Counter).Name, 1) = quot;_quot; Then _
x.Item(Counter).Delete
Next
CommandBars(quot;Reviewingquot;).Visible = False
End SubEnd Jim post.......................Gord Dibben Excel MVP

On Wed, 25 Jan 2006 10:02:03 -0800, Joe H. lt;Joe gt;
wrote:

gt;The quot;Reviewingquot; toolbar keeps appearing on the desktop. I remove it and it
gt;comes back up when I open Excel the next time. Is there any way to
gt;permanently keep this toolbar from appearing on the desktop until it is
gt;needed?

Gord Dibben MS Excel MVP

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()