Changing caption text and hiding buttons
 

Hello
I've written a fairly simple bit of code to change a form and make th
user of the reports aware that they are updating.
It works just fine without the macro attached, but when I call th
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 Su

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

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/

Changing caption text and hiding buttons
 

Fantastic.
Unfortunately I have to wait until tommorow morning to get into wor
and try it!

Thanks Tom really appreciate the help

Pau

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