Vba - generating button into worksheet

  • Thread starter Thread starter ajliaks
  • Start date Start date
A

ajliaks

Hi all,

I will apreciate any help.

When opening worksheet "WSH" I need to show a button wich allows th
user to go to userform1.

I've tried making a userform which looks like a button, the problem is
in that case, that while userform is active, user cannot scroll up o
down in the WSH.

I need the button to appear when WSH initializes and stay on top o
page (allowing scrolling up or down) and when user clicks it it show
me userform1.

I hope someone can help on this.
Thanks in advance.
Aldo
 
This will create a Forms button

Sub AddFormsButton()

With ActiveSheet
.Buttons.Add(372.75, 46.5, 126, 63).Select
Selection.OnAction = "Macro1"
End With

End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top