+ Reply to Thread
Results 1 to 3 of 3

My buttons/checkboxes keep moving!

  1. #1
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    179

    My buttons/checkboxes keep moving!

    All,

    I have created a database with a homepage that has several buttons/checkboxes that control the database in various ways. Upon event 'workbook open', I am protecting all of the sheets in the database and ensuring that the homepage is the activesheet. The problem I am having is that this macro appears to move all of the buttons/checkboxes on the homepage! It seems like a very strange glitch that I can't work out what in the world is going on!

    Here's the spreadsheet (I have taken the majority of the sheets out to reduce the size to enable uploading):
    Ns By Area Edit2.xlsm

    As you can see, when you open the spreadsheet, the "raw mats" checkbox and button are shifted to the top left hand corner of the screen. If you click on either of them, they move back to where they should be (in the centre). Any idea why this is happening? :s

    Thanks in advance.
    Did I help? Click *- add to my rep.

  2. #2
    Valued Forum Contributor
    Join Date
    10-26-2008
    Location
    Birmingham, UK
    MS-Off Ver
    All versions up to 2010
    Posts
    1,025

    Re: My buttons/checkboxes keep moving!

    Hi
    On the sample you uploaded there is only one button on the Homepage (Raw Data) and it doesn't move for me . Which buttons move for you or is it that I don't have all the buttons on the Homepage that you have.
    Tony

  3. #3
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Melbourne
    MS-Off Ver
    Excel 2010
    Posts
    179

    Re: My buttons/checkboxes keep moving!

    There is a 'raw mats' checkbox and a 'raw mats' button and they move to the top left for me. On the full database there are 4 checkboxes and 4 buttons and they all move to the same place in the top left hand corner. I've tried to same document on a different computer and get the same problem.

    To clarify, the buttons are supposed to be in the centre of the screen under the "click to show..." titles.

    EDIT: Now it seems to have fixed itself but I don't know what I did to fix it!
    Last edited by Brumbot; 06-07-2013 at 09:28 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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