Hello everyone,
To create a button I know how to insert and select the range in a sheet to locate the button.
My question is : Is that possible we can create a button who is not just belongs to a special sheet but it is a global like button?(the global like means it will float over any worksheets even including new sheet created in the future)
Thank you!
Why not place button in the ribbon?
http://www.excel-easy.com/vba/exampl...e-toolbar.html
If you need it for single workbook, you can skip the steps to add to Personal.xlsb.
Just customize ribbon and add custom group and add your macro under it.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Thank you very much CK76! It works!
But the new button will show up at every other excel too. while I only need this function in a specific excel file only.
Last edited by qzlvyh0524; 11-20-2017 at 04:56 PM.
Also you can add it to the context menu.
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx
You can make it appear and disappear based on the active book
Please Login or Register to view this content.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
That's going to be bit more involved. See Ron de Bruin's site for details.But the new button will show up at every other excel too. while I only need this function in a specific excel file only.
https://www.rondebruin.nl/win/section2.htm
http://www.rondebruin.nl/win/s2/win001.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks