+ Reply to Thread
Results 1 to 4 of 4

get error with xlhidden sheets macro

  1. 03-07-2018, 07:55 AM #1
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    get error with xlhidden sheets macro

    I am using the macro below for Xlveryhidden for three sheets but getting runtime error , unable to set visible property of sheets class

    There are 4 sheets in the workbook sheet workings should remain unhide.



    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-07-2018, 08:06 AM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: get error with xlhidden sheets macro

    You have a trailing space on Summary Report. I suspect it could be that.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 03-07-2018, 08:06 AM #3
    xlnitwit
    xlnitwit is offline
    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: get error with xlhidden sheets macro

    Hi,

    You'll need to loop
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  4. 03-07-2018, 08:14 AM #4
    JEAN1972
    JEAN1972 is offline
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    Re: get error with xlhidden sheets macro

    Thank you working now
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. need a macro to get rid of negative numbers and value error on 100 sheets pf workbook
    By prdponce in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-02-2015, 04:18 PM
  2. Sudden 'Compile Error' message in browse sheets macro.
    By henryBukowski in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-23-2013, 06:19 AM
  3. [SOLVED] Macro error when ran on multiple sheets on workbook (even though macro works)
    By steven_e in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2012, 06:09 PM
  4. Two macro enabled excel sheets opening at a time causes error
    By gaurisneha in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2012, 12:57 PM
  5. [SOLVED] Copy to new sheets by group macro error
    By jlax34 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 11:53 AM
  6. Macro that creates duplicate sheets. Random Error.
    By timmtamm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2011, 12:25 PM
  7. Compile Error WBs to Sheets Macro
    By capnhud in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-21-2010, 11:57 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1