Excel Custom Tab Stopped Displaying

Joined
Nov 30, 2010
Messages
1
I have a custom Excel tab that I created using a XLAM file in the AddIns folder. The custom tab has two buttons at the moment that point to two macros in the XLAM file. I recently created a new macro in the XLAM file; however, when I unzip the XLAM file to tweak the customUI.xml file by adding a new button to the custom tab the custom tab disappears completely when I zip it back up as a XLAM file. Below are details and what I've tried so far:

- I am running Excel 2007 on WinXP SP3.

- I have tried removing the new macro completely and making a slight change to the customUI.xml file to see if the change shows up. When I zip the folder back up into an XLAM file the custom tab disappears. Okay, so it's not my new macro.

- I've tried copying the file, unzipping it, re-zipping it back up (with no changes) and renaming it to the original file name, but the custom menu disappears. (I made sure that the Add On was enabled in the Excel Options.)

- When I look at the properties of the duplicated XLAM file (right click>Properties), the summary tab options are all grayed out (the original XLAM file summary tab is not grayed out).

- When I compare the file size of the original XLAM to the copy, there is a very small change in file size. This makes me think that it has something to do with the zipping process on my system, but I'm just not sure. It's one of those "right-click>Send to>Compressed Folder" things.

- As far as I can tell, nothing on my system has changed since I originally created the first XLAM file. I'm all out of ideas at this point.

Any help or ideas are much appreciated.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top