Button in Excel forced to be on foreground on all applications

robbs

New member
Joined
May 19, 2012
Messages
1
Reaction score
0
Points
0
Hello friends,can anyone help me?
i have made a button in Excel - VB ,i want to force this button(only not excel) always to be on foreground , on all applications , even when the excel is minimised this button will be foregrounded on top of all applications.


Thanks
Robbs
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Unfotunately the buttons on an Excel sheet are contained as part of the Excel file. So minimizing Excel will take the button with it. I'm not aware of any way to fix that.

You may be able to get help doing this using VB.Net at http://www.xtremevbtalk.com/ though... Not promissing, but they may be able to find a way. The solution won't be driven from Excel though, that I can assure.

Good luck,
 

GaryA

New member
Joined
Apr 6, 2012
Messages
51
Reaction score
0
Points
0
Can the button be moved to the Windows Taskbar instead?
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Nope. The button is equivalent to the text in cell A1. It's part of Excel.

Depending on the version of Window you're running you could create a shortcut or pin a file to the windows taskbar, but that would give you the workbook, not the button.
 
Top