Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Buttons | Excel Discussion (Misc queries) | |||
Collapsing/Hiding radio and macro buttons | Excel Discussion (Misc queries) | |||
hiding/unhiding rows & columns with "+" and "-" buttons | Excel Discussion (Misc queries) | |||
Sort buttons by caption? | Excel Programming | |||
changing the caption of a label | Excel Programming |