Toolbar question

  • Thread starter Thread starter Kenneth E. Coakley
  • Start date Start date
K

Kenneth E. Coakley

Despite repeatedly "unchecking" the Reviewing toolbar in the toolbars list,
it still returns often.

- What is triggering this toolbar to return?

- Is there anyway to disable it from automatically popping up?

Thanks!
Ken
 
Ken

Quoted posts from others....................

Start Peo Sjoblom************************

Tell the people who email you not to use File>Send To Mail Recipient (for
review) and use (as attachment)instead. That is what triggers it

End Peo Sjoblom*********************

Start Jim Rech*******************

Actually I believe the annoying popup Reviewing toolbar is triggered by
certain custom file properties. Go into File, Properties and the Custom
tab. There you will probably find several custom properties that begin with
underscores (as I recall). If you delete them and save the workbook and
close the Reviewing toolbar, I think the next time you open the workbook the
toolbar will not appear.

End Jim Rech**************

Gord Dibben Excel MVP
 
Ah hah! Great information, thanks Gord.

Ken


Gord Dibben said:
Ken

Quoted posts from others....................

Start Peo Sjoblom************************

Tell the people who email you not to use File>Send To Mail Recipient (for
review) and use (as attachment)instead. That is what triggers it

End Peo Sjoblom*********************

Start Jim Rech*******************

Actually I believe the annoying popup Reviewing toolbar is triggered by
certain custom file properties. Go into File, Properties and the Custom
tab. There you will probably find several custom properties that begin with
underscores (as I recall). If you delete them and save the workbook and
close the Reviewing toolbar, I think the next time you open the workbook the
toolbar will not appear.

End Jim Rech**************

Gord Dibben Excel MVP
Click to expand...
 
Effect
Sometimes, when an email you receive contains an Office attachment, the
attachment, when opened, will also open the "Reviewing" toolbar.
This applies mainly to Excel 2003, although the effect might be seen in
other versions.

Cause
The email/attachment has been sent using Outlook which has automatic review
turned on.
Outlook sometimes adds custom properties to Office attachments, including
your email address.
Another is "_ReviewingToolsShownOnce"

Resolutions
1) After saving these files for the first time, the "Reviewing" toolbar
shouldn't appear again.
Or
2) Delete the custom properties
1. Open the Office document
2. Click File in the menu bar
3. Then click Properties
4. Select the Custom tab
5. Select each property you wish to remove and click Delete
Or
3) Ask your colleagues to change their Outlook settings:
How to Turn Automatic Review Off in Outlook
Click Tools in the menu bar
Select Options
On the Preferences tab click E-mail options.
Then click Advanced E-mail options.
At the bottom disable "Add properties to attachments to enable Reply with
Changes"

Other
How can I still send documents for review?
On the File menu select "Send to"
Select "Mail Recipient (for Review)"


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
Andy...

Thanks for the additional info. That's just what I needed to know!

Ken
 
Back
Top