+ Reply to Thread
Results 1 to 2 of 2

VBA - Checkboxes to Unhide Rows + Multiple Users

  1. #1
    Registered User
    Join Date
    02-09-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    2

    Exclamation VBA - Checkboxes to Unhide Rows + Multiple Users

    VBA Codes Used:
    1. Macro-Enabled Excel 2010 file with multiple checkboxes on sheet1 (Form) that will unhide rows on sheet2 (Questions), code saved directly in Sheet1 in VBA;
    2. 1 "Reset" button on sheet1 (Form) to uncheck all checkboxes, the code is set as a module and assigned to button;
    3. 1 "Unhide/Hide" button on sheet2 (Questions) that unhides or hides all rows when clicked, the code is set as a module and assigned to button.


    Situation: My office works on a shared network, we have a sharefile folder that I upload the excel document to for multiple users to access when needed. The only time the document is edited is when the questions on sheet2 (Questions) change or when text is added/deleted. When that happens I rework the VBA code to match the checkboxes to the specified questions, save document. Everything was working just fine for almost an entire year until recently the codes stopped working for everyone except me. Everyone enables their computers to run the macros but suddenly some people recieve a runtime error when clicking the buttons or nothing happening at all when the checkboxes are checked. Other people can't even click in the document as everything acts as if it is locked.

    Older documents with old questions work fine for everyone. No errors, same code. I thought maybe the document was corrupted so I created a brand new macro-enabled document and hand wrote all the questions all over again and recoded everything. Same errors for everyone EXCEPT me. I am not saving to a personal file, I am not doing anything different than before. All users have Excel 2010 and make sure their macros are enabled when opening document. They tried saving the document to their desktops and opening it, same issue.

    Test Document with same codes used:
    TestBook.xlsm



    Sheet1 (Form) VBA Code Used:
    Please Login or Register  to view this content.
    Module1 used to Reset checkboxes with button on sheet1:
    Please Login or Register  to view this content.
    Module2 used to unhide/hide with button on sheet2:
    Please Login or Register  to view this content.
    I have no idea what is going on. I feel like I have tried everything. I am still in the beginning stages of understanding VBA and Macros so can anyone help me out with this issue I am having? Why does everything work perfectly for me, but no one else? Why did it work before for everyone, but not now? I'm at a loss here.
    Last edited by Typokween; 02-17-2016 at 03:18 PM.

  2. #2
    Registered User
    Join Date
    02-09-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    2

    Re: VBA - Checkboxes to Unhide Rows + Multiple Users

    Sorry, the attachement should work now. Also, is there a way to hide the rows in a way that I don't have to keep updating the row numbers whenever there is added questions?

+ 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. Replies: 4
    Last Post: 01-22-2015, 01:18 PM
  2. [SOLVED] Help Needed with Checkboxes to Hide or Unhide Rows
    By dgibney in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-25-2014, 11:39 AM
  3. [SOLVED] Hide/unhide rows with checkboxes
    By mixer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2014, 03:58 PM
  4. Replies: 2
    Last Post: 11-01-2013, 03:23 AM
  5. need macro to hide/unhide columns through multiple checkboxes
    By trier in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-31-2013, 04:00 PM
  6. Using multiple checkboxes as an index page to hide/unhide worksheets
    By Damien_Lee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2013, 07:24 AM
  7. Hide/Unhide Multiple Checkboxes
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2011, 09:35 AM

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