Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide Command button on close
Hi All,
I have a worksheet that has a command button. When the command button is clicked it emails the form. I need to hide the command button and the row where it is located on the form. There are several things that happen when the command button is selected. Everything works until I get to the send email part so I have listed the part where I seem to be stuck. I have tried the following ActiveSheet.Unprotect Shapes("CommandButton2").Visible = False Rows("44:47").Select Selection.EntireRow.Hidden = False Rows("34:35").Select Selection.EntireRow.Hidden = True Range("B2:C2").Select ActiveSheet.Protect ActiveWorkbook.SendMail "***", ActiveSheet.Range("X5").Text ActiveWorkbook.Close Savechanges:=False When the command button is clicked it unhides rows 44:47, Selects cell B2:C2, Protects the sheet, sends the email, closes without saving changes. But it will not hide the command button or the rows 34:35. What am I missing? Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Close Button Excel 2007 | Excel Discussion (Misc queries) | |||
Hide command button | Excel Programming | |||
Hide all Excel tool/command bars except mine and reload on close | Excel Programming | |||
how do you hide a forms command button | Excel Programming | |||
Hide command button on worksheet | Excel Programming |