+ Reply to Thread
Results 1 to 3 of 3

Tool bar creation

  1. #1
    Registered User
    Join Date
    02-18-2009
    Location
    Apex, NC, USA
    MS-Off Ver
    Office 365
    Posts
    64

    Unhappy Tool bar creation

    I have been running Excel 2010 and switched to 2013. After switching yesterday, the creation of my tool bar that I do with a start-up macro in my Personal workbook worked just fine. The tool bar, visible when I select Add-Ins on the ribbon showed in both my personal workbook and the "application" workbook where I actually use the tool bar (the macros assigned to the icons). ...all desired. Today for some unknown reason, the tool bar is created successfully ONLY in the Personal workbook. (or at least it's only visible there.) It's not there in the "application" workbook that is the one I initially open. I have tried to change the trust center setting in both the Personal and "application" workbook, but I haven't found settings that fix the problem. I know that the tool bar creation macro is actually running because I have set a stop in the VBA code and then stepped through the execution. We are dead in the water. Can anyone please help? Is there perhaps some change in the VBA parameters when creating a tool bar that says whether the create applies to all open workbooks or to just "this workbook". In playing with the workbooks, once I got it to show the toolbar in the application workbooks (I'm not sure why it happened...but then when I opened the workbooks the next day, the behavior of not showing the tool bar in the application workbook retuened.
    Last edited by DanBlum; 05-14-2014 at 02:05 PM. Reason: more explanation

  2. #2
    Registered User
    Join Date
    02-18-2009
    Location
    Apex, NC, USA
    MS-Off Ver
    Office 365
    Posts
    64

    Re: Tool bar creation

    OK... I rebooted my machine and problem went away! ....and now it's come back.. Any help would be appreciated.
    Last edited by DanBlum; 05-14-2014 at 02:06 PM. Reason: problem returned.

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Tool bar creation

    You may click thread tools link at top of page and mark solved.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

+ 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. SKU creation
    By handbaked in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2013, 02:48 PM
  2. Advanced Excel Tool Creation Help - Gap Analysis style
    By Diamond Dog in forum Excel General
    Replies: 4
    Last Post: 09-19-2012, 12:00 PM
  3. Excel file creation dates do not match the windows creation date.
    By alexthapyro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-26-2011, 12:14 PM
  4. [SOLVED] I am missing view tool bar from tool menu.
    By excel in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-04-2005, 03:05 PM
  5. Creation Help
    By cantbebawt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2005, 12:32 PM

Tags for this Thread

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