LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Cut Button Problem

Jim;
Thanks very much

Maperalia
"Jim Rech" wrote:

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
|



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command Button Problem albertmb Excel Discussion (Misc queries) 6 June 22nd 08 01:06 PM
Problem with copying a button in VB Trefor Excel Programming 0 January 19th 06 11:50 AM
Option Button problem Paul Excel Programming 2 April 18th 05 05:43 PM
Option button problem Roy Miller[_2_] Excel Programming 0 July 31st 04 01:04 AM
Command Button Problem del Excel Programming 3 November 21st 03 05:13 PM


All times are GMT +1. The time now is 05:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"