ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tool Bar (https://www.excelbanter.com/excel-programming/338608-tool-bar.html)

pkbravo

Tool Bar
 

Everytime i open excel the "reviewing" toolbar opens with it. I've gon
into the Personal.xls and closed it and resaved it, but it keeps commin
up everytime excel opens. Can some someone please let me know how t
stop this from happening. Does anyone have any code to close i
everytime excel is opened? Any help would be greatly appreciated. :

--
pkbrav
-----------------------------------------------------------------------
pkbravo's Profile: http://www.excelforum.com/member.php...fo&userid=1513
View this thread: http://www.excelforum.com/showthread.php?threadid=40003


Jan Karel Pieterse

Tool Bar
 
Hi Pkbravo,

Everytime i open excel the "reviewing" toolbar opens with it. I've gone
into the Personal.xls and closed it and resaved it, but it keeps comming
up everytime excel opens.


Open the Visual Basic editor (alt-F11), hit control-g and type this line,
followed by an enter:
Application.Commandbars("Reviewing").Enabled=False

Set it back to True whenever you do need the toolbar.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com



All times are GMT +1. The time now is 09:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com