Thread: Changing caption text and hiding buttons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Changing caption text and hiding buttons
Private Sub ClickYes_Click()

MarketLabel.Caption = "Running Reoprts"
ClickYes.Visible = False
ClickCancel.Visible = False
me.repaint
doEvents
ReportMacro

Me.Hide

End Sub

--
Regards,
Tom Ogilvy


"Paul_Russell " wrote in
message ...
Hello
I've written a fairly simple bit of code to change a form and make the
user of the reports aware that they are updating.
It works just fine without the macro attached, but when I call the
macro in the line afterwards the form fails to update.

Any ideas?

Cheers
Paul

Private Sub ClickYes_Click()

MarketLabel.Caption = "Running Reoprts"
ClickYes.Visible = False
ClickCancel.Visible = False

ReportMacro

Me.Hide

End Sub


---
Message posted from http://www.ExcelForum.com/



Reply With QuoteReply With Quote