+ Reply to Thread
Results 1 to 6 of 6

Macro stopped woring - worked 100's of times before (Hide/unhide)

  1. #1
    Registered User
    Join Date
    04-06-2016
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    89

    Macro stopped woring - worked 100's of times before (Hide/unhide)

    I've always used this to hide/unhide months (Have 12 months, just included juli to show)
    It have worked 100's of times - suddenly it doesn't - when I try to use the checkboxes(for the true/false in F31) it shows me a debugger saying - in my poor translation

    Run-time error '1004':
    Can't define option hidden for the class Range


    Please Login or Register  to view this content.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Macro stopped woring - worked 100's of times before (Hide/unhide)

    Hi,

    Is the sheet protected that you are trying to change?

  3. #3
    Registered User
    Join Date
    04-06-2016
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    89

    Re: Macro stopped woring - worked 100's of times before (Hide/unhide)

    They always were with an autoprotect in the workbook_open - so that was my first thought too - but it doesnt matter if I unprotect everything - same protected/not

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Macro stopped woring - worked 100's of times before (Hide/unhide)

    Is the error occurring on all sheets or is it only one specific one?

  5. #5
    Registered User
    Join Date
    04-06-2016
    Location
    Sweden
    MS-Off Ver
    2016
    Posts
    89

    Re: Macro stopped woring - worked 100's of times before (Hide/unhide)

    All sheets, all checkboxes (Theres 12, one for each month)

    And it's ALWAYS worked up untill now.

    12 months of data in each sheet - but the checkboxes determine which are hidden/shown, So if I check Juli, all columns not involved with Juli is hidden ans so on.

  6. #6
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Macro stopped woring - worked 100's of times before (Hide/unhide)

    Can you attach a copy of your workbook please?

+ 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. Hide Visibility hide and unhide menu using macro ?
    By jasond1992 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2015, 09:05 PM
  2. [SOLVED] Hide/Unhide Macro Help
    By EbenezerNa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2013, 03:28 AM
  3. [SOLVED] hide/unhide macro
    By aaron061883 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-30-2013, 08:01 PM
  4. [SOLVED] hide and unhide macro
    By aaron061883 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2013, 07:12 PM
  5. [SOLVED] hide/unhide macro
    By Matt in forum Excel General
    Replies: 2
    Last Post: 04-06-2006, 02:30 PM
  6. hide/unhide row macro
    By Checkman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2006, 05:50 PM
  7. hide/unhide macro
    By zenahs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2005, 02:40 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