Results 1 to 1 of 1

Command Button moving from right to left

Threaded View

JP Romano Command Button moving from... 02-11-2009, 11:58 AM
  1. #1
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Command Button moving from right to left

    I'm sure this is a no brainer, but for some reason it escapes me (perhaps due to lack of brain).
    I have an Excel 07 spreadsheet with several tabs, buttons, and macros. At the top of one of those tabs, generally aligned with Column R, is a Command Button.
    When the user has completed all the procedures, he/she clicks another command button, which removes all the data from the workbook (deleting rows/columns instead of clearing them) and rebuilds all the named ranges.

    The button in question gradually moves to the left, not aligned with any cells or columns, mind you, but just a bit at a time every time the data is cleared out.

    I have the button format set to "do not move or size with cells" and the properties
    AutoSize = False
    Locked = True
    Placement = 3 (no idea what that means and can't find a good description)

    Anything obvious that I'm missing?

    Thanks in advance
    JP (smartest idiot around)
    Last edited by JP Romano; 02-11-2009 at 12:10 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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