Hello
Since you don't give much details, I would suggest you check for the
TakeFocusOnClick property of your button on your worksheet.
Set this property on False.

HTH
Cordially
Pascal

"shivboy" a écrit
dans le message de news:
...

Hi,

I am getting a "Error '9' : Subscript out of range" error while opening
a user form from a button on a sheet. Why is this happening? I checked
for typo errors, but there aren't any. What do I do?

Peace,

Shivboy


--
shivboy
------------------------------------------------------------------------
shivboy's Profile:
http://www.excelforum.com/member.php...o&userid=35137
View this thread: http://www.excelforum.com/showthread...hreadid=553956