problem command button

[bam12]

i made a command button from the control toolbox
put code in it
and not i cant edit it
it like it is protected

any idea how to fix this

 

[Norie]

Can't edit what?

The code or the button?

If it's the button then the problem is probably that you aren't in design mode.

To enter design mode click the set square in the top left on the Control Toolbox toolbar.

 

[bam12]

button

i can edit buton
i am in edit mode
when i place cursor over the button i get circle with line thru it

also in edit mode everything is ghosted

 

[bam12]

Private Sub CommandButton1_Click()

    Sheets(Array("Summary", "Completed")).Select
    Sheets("Summary").Activate
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

End Sub

Here is the code i have. it seems when I run the macro by clicking on the command button it act if it protected the worksheet, causing the above mentioned problem.

I can fix it by clicking on another worksheet and coming back to the one with the command button in it and it is ok.

Could it because I am missing something in code?

Thnaks for any help

 

[VoG]

Why not just

Private Sub CommandButton1_Click()
    Sheets("Summary").PrintOut Copies:=1, Collate:=True
End Sub

 

[bam12]

more sheets

i have 7 worksheets in the workbook but only print 2 of them,

summary and completed

 

[VoG]

Private Sub CommandButton1_Click()
    Sheets(Array("Summary", "Completed")).PrintOut
End Sub