View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Cut Button Problem

statement where all the buttons will be cut

Activesheet.Buttons.Delete

--
Jim
"maperalia" wrote in message
...
|I have an statement (see below) which delete all the buttons (button 13 &
| button 14). The macro is running ok when I run the macro for first time,
| however, when I run it for second time on the row the macro does not
| recognize the button 13 and button 14.
|
| I wonder if there is a way to have an statement where all the buttons will
| be cut on specific sheet regarless the number its has. In another words
| without mention button 13 & button 14.
|
| Thanks in advance.
| Maperalia
|
|
| ActiveSheet.Shapes("Button 13").Select
| Selection.Cut
| ActiveSheet.Shapes("Button 14").Select
| Selection.Cut
| Range("C3").Select
|