LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default vba code to block review toolbar


Todd F wrote:
*In my little world I get many excel files sent to me.

I would be very greatful if someone was to enlighten me
with the the code need to block the review toolbar form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it out of
my excel. Line by line if need be.

Thanks you for your time.

Todd *


Cudos to Ron de Bruin and Jim Resch. I have suffered for years with
Reviewing Toolbar, in my own Word docs, and when it showed up in an
Excel file too, I went looking for, and found their answers.
But for solving my own creating of Word docs with Reviewing Toolbar I
used Word to open the Normal.dot template (File - Open - C:\Documents
and Settings\my username\Application
Data\Microsoft\Templates\Normal.dot)
Once opened, I turned off the Reviewing Toolbar (View - Toolbars -
Reviewing toolbar) and then saved my changes.
Now when I create a new document, I'm no longer one of those that
generates documents that require the Reviewing toolbar.



--
jacksprat
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message818309.html

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I stop the Web and Review toolbar opening up randomly? D Excel Discussion (Misc queries) 1 June 27th 06 07:19 PM
review toolbar reappears dave Excel Discussion (Misc queries) 1 April 13th 05 03:50 PM
code that might be causing error - please review and comment bruce forster Excel Programming 4 May 21st 04 03:06 AM
VB6 with Excel Objects: Please review my code Kurt Remlin Excel Programming 6 May 1st 04 03:36 AM
Two Questions about the Following Block of Code Greener Excel Programming 0 October 9th 03 06:26 PM


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"