Share via

Edit xl\attachedToolbars.bin

Anonymous
2013-02-13T21:37:28+00:00

Hi all,

Could it be possible to edit xl\attachedToolbars.bin? And if so: how?

Reason for this question:

  • 2003-workbook with custom toolbar with four buttons
  • converted to 2010.xlsm
  • three buttons (now on tab Add-ins, group Custom toolbars) work
  • the fourth produces an error: Workbook X not found.

This X-workbook is a Stonehenge-version in 2003.

I found a reference in xl\attachedToolbars wich I tried to remove.

Excel 2003 is no longer available ;-(.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-02-14T16:06:03+00:00

    Hi all,

    Thanks to Cindy Meister, I could solve my problem with good old VBA.

    With the command

    CommandBars(156).Controls("&Drill Down").OnAction = "PTDrillDown"

    I removed the reference to the ancient workbook.

    It seems to work.

    Was this answer helpful?

    0 comments