Yesterday, I wrote a macro and installed a custom tab with a button in that tab to run the macro. I emailed the Excel file to my boss. This morning when she opened the attachment, the custom tab/ribbon that I added was not there.
What happened? How can I ensure that it does not disappear when somebody else opens the workbook?
Could it be that the person on the receiving computer must have certain Object Libraries enabled?
Last edited by Excel_vba; 12-30-2013 at 11:30 PM. Reason: add
Because it is manually added in your ribbon which stays in your system excel alone.
So you have to write a code in on workbook_open event to create a custom menu on the ribbon and assign macro code to it via code.
On close you need to delete that button.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You may also use CustomUI XML in workbook to create your own tab. Code will only add buttons to Add Ins tab.
- 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks