View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul_Russell[_6_] Paul_Russell[_6_] is offline
external usenet poster
 
Posts: 1
Default 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