Private Sub PLabels_Click()
Sheets("PrintLabels").Select
ActiveSheet.Calculate

'event procedure
CloseExcelHLS

' command button
PrintLabels.Export.Enabled = True

'command button
PrintLabels.CloseExcelExport.Enabled = False
End Sub


The above is triggered from another sheet called PList. CloseExcelHLS is an
event and once it completes running the code stops at:

PrintLabels.Export.Enabled = True

Anyone got a solution for this?
Thank you if you can be of help.

Pat