at the beginning of your macro, add

application.screenupdating=false

and near the bottom add

application.screenupdating=true

then the screen won't jump around following your macro. will just
stay on the Menu sheet.
hth!
susan


On Feb 28, 9:07 am, "excelnut1954" wrote:
I have a sheet named Menu that contains command buttons the user will
choose from. I would like for the view to stay on Menu as the macro
executes. Is there a way to keep the focus on this sheet? Here's an
example of one of the button commands.

Private Sub CommandButton1_Click()
'Find Record via PO# - enter # and choose from Current or Deleted
sheet.

'Unhides columns for Search
Application.Goto Reference:="_2nd_PO_PL"
ActiveCell.Columns("A:N").EntireColumn.Select
Selection.EntireColumn.Hidden = False

' user will enter PO# to search for
UserForm12.Show

End Sub

Thanks,
J.O.