+ Reply to Thread
Results 1 to 3 of 3

Displaying only custom toolbars

  1. #1
    Registered User
    Join Date
    09-09-2008
    Location
    Canada
    Posts
    3

    Displaying only custom toolbars

    Hello,

    I am creating an Excel file that will be used by people who are not very familiar with Excel. This file is going to be on our network, and I would like it to display only one toolbar (a custom toolbar that I've created) when the file is open. I know how to attach a custom toolbar to the workbook, but don't know how to turn all the other toolbars in this file ONLY, so the workbook only displays one toolbar no matter which computer it is open on.
    Any help will be appreciated?
    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    Try this:

    alt+11, click "This workbook" add the following VBA code
    Please Login or Register  to view this content.
    Change the toolbar name as you need.

  3. #3
    Registered User
    Join Date
    09-09-2008
    Location
    Canada
    Posts
    3

    Many thanks

    Worked like magic on my computer! Tomorrow will test on the network. Thanks a lot!

+ 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. Display only custom toolbars
    By Truth Seeker in forum Excel General
    Replies: 1
    Last Post: 09-09-2008, 02:20 AM
  2. Custom Toolbars macro always refers to new saved filename
    By clng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-03-2008, 11:54 AM
  3. lock custom toolbars
    By jimb0693 in forum Excel General
    Replies: 2
    Last Post: 05-06-2007, 06:57 PM
  4. Displaying toolbars based on UserName and Workbook...?
    By Petitboeuf in forum Excel General
    Replies: 0
    Last Post: 11-13-2006, 02:21 PM
  5. Problem with custom toolbars
    By Willow in forum Excel General
    Replies: 0
    Last Post: 10-03-2006, 09:31 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