Results 1 to 9 of 9

Thread: on workbook open, form optionbutton loses position when unhidden

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    May 2012
    Posts
    25
    Rep Power
    0

    Unhappy on workbook open, form optionbutton loses position when unhidden

    Hi,

    i am currently facing a very odd problem with optionbuttons and groupboxes.

    i have generated a set of form optionbuttons on a worksheet on certain rows and placed inside groupboxes, where each groupbox encloses 4 optionbuttons.

    When i click the Reset button, the rows 14:56 hide along with the groupboxes and optionbuttons placed in them.
    when i click the UnReset button, the rows 14:56 unhide along with the groupboxes and optionbuttons placed in them.

    Now, the problem:

    when i Reset or Hide the rows, groupboxes and optionbuttons and then SAVE the workbook and close it, then when i reopen it again, and click the unReset button to unHide the rows, groupboxes and optionbuttons, i see that all the optionbuttons, groupboxes etc lose their positions and only line up on the starting row 14.

    P.S: i have not hidden the rows in the attached workbook, so that you can try and see the issue on your own.

    please advise.
    Attached Files Attached Files

Similar Threads

  1. Open And Activate Workbook Before Runing Macro
    By Howardc in forum Excel Help
    Replies: 5
    Last Post: 06-04-2013, 07:23 PM
  2. VBA Code to Open Workbook and copy data
    By Howardc in forum Excel Help
    Replies: 16
    Last Post: 08-15-2012, 06:58 PM
  3. Get Name List of All Open Workbook Files
    By princ_wns in forum Excel Help
    Replies: 5
    Last Post: 04-07-2012, 12:18 PM
  4. Assign an event to chart on workbook open
    By LalitPandey87 in forum Excel Help
    Replies: 2
    Last Post: 02-20-2012, 07:43 AM
  5. Replies: 1
    Last Post: 06-02-2011, 10:38 AM

Tags for this Thread

Posting Permissions

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