+ Reply to Thread
Results 1 to 8 of 8

Show all on Protected Sheet - error

  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    Philadelphia,PA
    MS-Off Ver
    2010
    Posts
    54

    Show all on Protected Sheet - error

    Hi all, I have a code that allows me to reset the filter before the workbook is closed. However, I get an error message if there is no filter in place. Can anyone help me put in a conditional statement that ignores the macro if there is no filter applied to the sheet? Thank you

    Please Login or Register  to view this content.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Show all on Protected Sheet - error

    maybe
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    09-19-2014
    Location
    Philadelphia,PA
    MS-Off Ver
    2010
    Posts
    54

    Re: Show all on Protected Sheet - error

    There is an error message on the show all data, as "ShowAllData method of Worksheet class failed"

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Show all on Protected Sheet - error

    is the data in a Table or a normal range?

  5. #5
    Registered User
    Join Date
    09-19-2014
    Location
    Philadelphia,PA
    MS-Off Ver
    2010
    Posts
    54

    Re: Show all on Protected Sheet - error

    The data is in normal range, and no columns are hidden

  6. #6
    Registered User
    Join Date
    09-19-2014
    Location
    Philadelphia,PA
    MS-Off Ver
    2010
    Posts
    54

    Re: Show all on Protected Sheet - error

    I have excel version 2013 if that helps

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Show all on Protected Sheet - error

    can you post a sample workbook where my code doesn't work?

  8. #8
    Registered User
    Join Date
    09-19-2014
    Location
    Philadelphia,PA
    MS-Off Ver
    2010
    Posts
    54

    Re: Show all on Protected Sheet - error

    I played around with it for a little, but got it to work with your suggestion. Thank you, JosephP!!

    Please Login or Register  to view this content.

+ 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: 1
    Last Post: 08-26-2013, 05:19 PM
  2. Option buttons show error in protected mode
    By jghender in forum Excel General
    Replies: 1
    Last Post: 12-28-2012, 10:19 PM
  3. Next entry row doesn't show on protected sheet.
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-01-2011, 12:50 PM
  4. Replies: 2
    Last Post: 11-04-2007, 01:07 AM
  5. show all function with sheet protected
    By tcob01@gmail.com in forum Excel General
    Replies: 9
    Last Post: 07-25-2006, 01:05 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