+ Reply to Thread
Results 1 to 3 of 3

Button on Sheet Disapears when columns or Rows are deleted

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Button on Sheet Disapears when columns or Rows are deleted

    I have a shape that I assigned a macro to on a sheet which delets rows and columns where the shape sits.

    is there a work around to not have the shape effected by whats going on in the worksheet when i click on the shape/button to run the macro?

  2. #2
    Valued Forum Contributor
    Join Date
    11-12-2014
    Location
    Nottingham
    MS-Off Ver
    2013
    Posts
    383

    Re: Button on Sheet Disapears when columns or Rows are deleted

    right click the shape and go to properties/ Format control and check "Don't move or size with cells"
    !If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
    If I helped do this, then please show your appreciation by awarding rep points.
    <------ Button for that is over there

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Button on Sheet Disapears when columns or Rows are deleted

    Thank You Marking this as solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Protect Rows and columns from being deleted
    By bigfishprf in forum Excel General
    Replies: 2
    Last Post: 03-10-2015, 05:27 PM
  2. update target sheet with rows as they are added or deleted to master sheet
    By RLR31064 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2014, 05:41 PM
  3. Replies: 1
    Last Post: 11-20-2013, 01:06 AM
  4. Button to Remove duplicate and pasting the deleted row in another sheet
    By lovinguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2013, 12:24 AM
  5. [SOLVED] only shows to column e (other columunnot hidden) deleted, cannot add new columns or rows
    By Northstjarna in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-08-2012, 09:24 AM
  6. Button macro to setup Columns And rows for sheet.
    By coolhit in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-13-2009, 06:43 PM
  7. Track Deleted rows and columns
    By centaur63 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2006, 12:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1