Vba - generating button into worksheet
 

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

--
Message posted from http://www.ExcelForum.com

Vba - generating button into worksheet
 

Not sure if this is what you want...

UserForm1.Show vbModeles

--
Message posted from http://www.ExcelForum.com

Vba - generating button into worksheet
 

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)

"ajliaks " wrote in message
...
Hi all,

I will apreciate any help.

When opening worksheet "WSH" I need to show a button wich allows the
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 or
down in the WSH.

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

I hope someone can help on this.
Thanks in advance.
Aldo.


---
Message posted from http://www.ExcelForum.com/