+ Reply to Thread
Results 1 to 7 of 7

Toolbar buttons that only appear for a specific workbook.

  1. #1
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    272

    Toolbar buttons that only appear for a specific workbook.

    I have an Excel tool (workbook) that I have built that has several buttons for it. The workbook has several sheets that all use the same buttons. I want to be able to put those buttons on a toolbar that will only appear and show in that work book, but not in other workbooks. Is this possible? Maybe it does not have to be a tool bar, maybe it can be something that just stays at the top of the screen for each sheet. So if I change sheets or move around on the sheet I still have the buttons and forms static on the top. Is this possible? What is it called so I can research?

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Search the Forum for ToolBars, there are several examples of code to create toolbars which is what you need.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    272
    Quote Originally Posted by royUK View Post
    Search the Forum for ToolBars, there are several examples of code to create toolbars which is what you need.
    Awesome, thanks... and these are toolbars that won't show up in other excel files?

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Quote Originally Posted by caliskier View Post
    Awesome, thanks... and these are toolbars that won't show up in other excel files?
    No because you create the ToolBar within the workbook using code.

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

  6. #6
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    272
    Quote Originally Posted by royUK View Post
    Thanks very much, this is very cool, looks like I have some research to do to make this work.

  7. #7
    Forum Contributor
    Join Date
    08-03-2005
    Posts
    272
    Ok so I am learning some things, is there a way to make a toolbar and add check boxes to it? See I am wanting a toolbar that has a button that functions based on what checkboxes are checked in the tool bar. I can do this with a pop-up form but would like it better in a toolbar that way the form will always be up and remain where it is as people change sheets. Thanks again.

+ 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. protection of a workbook + unprotecting specific cells + calculation auto
    By choubix in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2008, 07:49 AM
  2. Share a toolbar that calls macro from an add-in
    By Brigitte_P in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-22-2008, 08:53 AM
  3. Add multiple spreadsheets to single spreadsheet
    By tmotommyo in forum Excel General
    Replies: 5
    Last Post: 02-06-2008, 11:35 PM
  4. linking to open workbook
    By Mile029 in forum Excel General
    Replies: 1
    Last Post: 05-15-2007, 06:46 PM
  5. '02 Excel Workbook to Workbook...HELP!!!
    By shutterlug in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-01-2007, 11:12 PM

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