Button in Excel forced to be on foreground on all applications

[robbs]

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]

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]

Can the button be moved to the Windows Taskbar instead?

[Ken Puls]

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.