+ Reply to Thread
Results 1 to 4 of 4

Hide tool bars

  1. #1
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Hide tool bars

    Hi,

    I am using the code below to hide my formula bar among other things.
    Currently it affects all files, can it be modified to run only for one file and specific worksheets?

    Thanks
    Kevin

    Please Login or Register  to view this content.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,309

    Re: Hide tool bars

    Set everything back to true in a Workbook_Close() event.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,438

    Re: Hide tool bars

    The Workbook_Deactivate() event maybe better
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    05-30-2015
    Location
    Dubai
    MS-Off Ver
    Excel 2016 Mac & PC & 365
    Posts
    633

    Re: Hide tool bars

    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Data the same but Tool Bars are different
    By Bob Newton in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-20-2019, 01:24 PM
  2. Full screen & tool bars hide
    By rooky in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 06-26-2012, 09:31 AM
  3. Hide/Show Menus/Tool Bars- Hides Tabs
    By MrBill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2010, 12:42 PM
  4. Tool Bars
    By Mordred in forum Excel General
    Replies: 4
    Last Post: 07-23-2010, 03:39 PM
  5. Docking Command bars? (tool bars)
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-06-2009, 03:51 PM
  6. [SOLVED] Disabling tool bars
    By Mike Rogers in forum Excel General
    Replies: 1
    Last Post: 12-06-2005, 01:25 PM
  7. Lost all my menu bars and tool bars
    By CathyJ in forum Excel General
    Replies: 3
    Last Post: 08-08-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1