Results 1 to 6 of 6

check boxes have all bunched up in the wrong cells after hiding rows

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2017
    Location
    sydney australia
    MS-Off Ver
    2016 32 bit excell 365
    Posts
    4

    check boxes have all bunched up in the wrong cells after hiding rows

    hi all
    I am hoping you can help me
    i am editing a spreadsheet where previous employees have used check tick boxes in cells.

    now im not sure if this problem is due to using a different version of excell, i think the problem occured when i hid a whole bunch of rows so i could see the headings up the top.

    then the next time i opened the file, all the check boxes have bunched up and moved down the page as shown.

    could someone please tell me how i can either get the check boxes back where they were, there are hundreds of them.

    or delete them all as they appear to be slowing down scrolling of the sheet.
    I will replace them with 'y' in the cells instead.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hiding form control check boxes
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-03-2016, 07:14 AM
  2. Hiding Rows based on two different Drop down Boxes
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2014, 09:47 AM
  3. Hiding rows with Check boxes in Excel 2010
    By BenX2010 in forum Excel General
    Replies: 1
    Last Post: 02-05-2014, 05:08 PM
  4. Hiding Check Boxes In VB excel 2007.
    By kukukokopufs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2012, 08:38 AM
  5. Hiding Check Boxes In VB excel 2007.
    By Starrysky in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-10-2008, 06:03 PM
  6. Check Boxes Hiding
    By leelee23 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-10-2007, 08:16 AM
  7. Hiding Check boxes
    By Sparrow in forum Excel General
    Replies: 2
    Last Post: 11-21-2006, 05:34 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