Commandbutton enable/disabling
It is hard to tell from the code you have posted. My only suggestion is that
if you have cmd buttons that you are trying to manipulate and it won't work
try being more explicit in your declarations. Reference the sheet or form
that the button is on prior to referencing the button... Something like
Sheet1.CommandButton1.enabled = false
HTH
"Pat" wrote:
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
|