View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default "floating" button

Rather than add the button to the worksheet add a button to the toolbar in
excel. Go to View Toolbars - Customized.
Select Macro - Custom Button.
Drag button to toolbar.
Doble Left Click new button to assign to a macro.

"pswanie" wrote:

i go right click on tools, click on forms and through that add a button to
wich i then assign a macro..

how (if possible) can i have that to "float" when users scroll up/down on a
worksheet?

thanx phillip