PDA

View Full Version : [SOLVED:] Disabling Reviewing Toolbar



robhigg_76
03-16-2005, 09:04 AM
My biggest pet peeve right now is when someone sends me a spreadsheet, and when i open it, it will launch the reviewing toolbar. Is there a way to disable this toolbar, or hide it so i do not see it?

Thanks,
Mike

Jacob Hilderbrand
03-16-2005, 09:22 AM
Here is the code you need to disable the command bar.


Application.CommandBars("Reviewing").Enabled = False

Put it in the open event in personal.xls and see if that helps.

Richie(UK)
03-16-2005, 01:37 PM
Hi Mike,

You may also be interested in some of the points discussed here (http://www.ozgrid.com/forum/showthread.php?t=28494&page=1&pp=10&highlight=reviewing+toolbar)

HTH