Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a slight problem I am hoping the guru's can help me
with. Currently, I have a sheet that has a button that calculates a few cells when pressed. I would like the button to be Visible = False but after it has been printed, bring the button back. The code I have is: Private Sub Workbook_BeforePrint(Cancel As Boolean) If Sheets(13) Is ActiveSheet Then Sheets(13).Shapes("CommandButton1").Visible = False Else: End If End Sub I can't bring the button back into the above procedure, becuase when it hits End Sub, but button will be visible and end up on the hard copy. Any ideas how I can bring the button back to Visible = True AFTER the above has ran? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print preview error from BeforePrint macro | Excel Discussion (Misc queries) | |||
BeforePrint macro | Excel Discussion (Misc queries) |