Button is not part of current Excel file

HuaminChen

New Member
Joined
Nov 13, 2018
Messages
16
[FONT=&quot]Hi,[/FONT]
[FONT=&quot]In this Excel [/FONT]file[FONT=&quot], it seems the relevant button is still "belonging" one other Excel file. How to ensure everything is part of current Excel file?[/FONT]
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
What do you mean relevant button? If it is in the ribbon, it is linked to the computer you use. It is possible to associate to a file through ui editor...but it is quite complicated. It is like creating a ribbon within the file, so the button is integrated in the invisible properties of the file

It is much simpler to use activX buttons, right click them and in the code section, paste the macro. An ActivX and its code will always be part of the file, still work if you send them by mail and open them on another computer...so I guess is what you want.
 
Upvote 0
If you open attached file and press any button, you can see button "is" of another Excel file. How to correct it?
 
Upvote 0
I don't kmow but in format control there is a tab with properties. The button could for example be protected with the sheet. In developer tab, there is a design mode option which could help and a Properties option as well.

Note that this is a standard button, not an ActiveX button.
I would change it for an ActiveX and put the code in "View Code" which would be in the sheet as button_click event.
 
Upvote 0
You're in the text box for the button. Exit that, then right-click the button and choose Assign Macro to see which one is assigned. Note: I would never recommend switching to ActiveX unless you have a very specific need for it.
 
Upvote 0
Cross posted https://www.excelguru.ca/forums/sho...-part-of-current-Excel-file&p=39406#post39406

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0
Just FYI, that crosspost has since been deleted, but the principle remains.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,208
Members
448,554
Latest member
Gleisner2

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