Command Buttons changing size!

G

Guest

I have a fairly large workbook that has one main screen. On this screen I have to command buttons. While i am working on the sheet I notice that everytime i click on either button they will grow a little bit or the font size will increase. This is very annoying. I would appreciate any suggestions
 
D

Don Guillett

Change to a button from the FORMS menu

--
Don Guillett
SalesAid Software
(e-mail address removed)
dcstech said:
I have a fairly large workbook that has one main screen. On this screen I
have to command buttons. While i am working on the sheet I notice that
everytime i click on either button they will grow a little bit or the font
size will increase. This is very annoying. I would appreciate any
suggestions
 
W

William

dcstech

Private Sub CommandButton1_Click()
'Existing code here
With CommandButton1
..Height = 38
..Width = 28
..Font.Size = 10
End With
End Sub

--
XL2002
Regards

William

(e-mail address removed)

| I have a fairly large workbook that has one main screen. On this screen I
have to command buttons. While i am working on the sheet I notice that
everytime i click on either button they will grow a little bit or the font
size will increase. This is very annoying. I would appreciate any
suggestions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top