Align Macro Control

[Jeff Podgorski]

Hello,

I'm trying to align macro controls and when I go to Format+Align the options are not highlighted for use; how can I make them usable.

Thanks

 

[Diablo II]

With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
End With

 

[Jeff Podgorski]

Thanks for the help; I'm very new to VBA.

Here's the code I'm using; where would I enter your recommendation? Also, FYI I have 15 form controls (buttons) I'm attempting to align.

ActiveWorkbook.Unprotect
Sheets("Reefer 3").Visible = True
ActiveWorkbook.protect Structure:=True, Windows:=False

Thanks

With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
End With