+ Reply to Thread
Results 1 to 3 of 3

Unhide 'very hidden' protected sheet

  1. #1
    Forum Contributor
    Join Date
    11-09-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    390

    Unhide 'very hidden' protected sheet

    Hi All,

    I have a workbook with a visible sheet and 'very hidden' protected multiple sheets. See attached 'Sheet1' as visible, 'Sheet2' and 'Sheet3' as protected very hidden.

    I used the following code to unhide the sheets which worked fine in the past but it looks like it does not do anything when I run it now. I open VBA double click on 'Thisworkbook' and insert the code there but nothing happens. when I used previously, after running the code it opened a new normal excel workbook (no macro-enabled) with all the sheets visible. Could you please let me know where I go wrong and advise please?

    Thanks

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Unhide 'very hidden' protected sheet

    Hi


    This is an empty workbook and looks like it's an attempt to use the code to break Excel security in another workbook, and if so contrary to Rule #7 of our Forum RULES: Don't post questions regarding breaking or bypassing any security measure.

    [/B]

    What's your motive for wanting to do this in this empty workbook?

    NO help to be provided until we understand what's going on here.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Unhide 'very hidden' protected sheet

    EDIT: I posted this after researching and without preview, so missed Richard's post. We seem to be on the same page.

    Quote Originally Posted by hanif View Post
    I used the following code to unhide the sheets which worked fine in the past
    There is no line of code in there that unhides a sheet, only unprotects. And it only does it for the active sheet. Also this code does not save a non-macro copy. If this used to work, you must have changed it, or you have another sub that loops through the sheets and calls this sub. I don't want to dig into that until you sort out that aspect of your requirement.

    Also this code appears to be an attempt to break a password, but would only work in a particular situation. I will give you one post to explain why this is a legitimate question or your thread will be deleted as a rule violation.

    Administrative Note:

    Welcome to the forum.

    Sorry, but your post does not comply with Rule #7 of our Forum RULES:

    Don't post questions regarding breaking or bypassing any security measure.

    Such threads will be closed and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or the posting of code to remove passwords.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Unhide hidden sheet when excel starts up with VBA
    By Rudidw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2015, 02:13 AM
  2. Unhide very hidden sheet bar?
    By Here2learn in forum Excel General
    Replies: 4
    Last Post: 10-06-2015, 06:36 AM
  3. Unhide Hidden Sheet when search button is used
    By cjames2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2014, 11:04 PM
  4. [SOLVED] Macro for very hidden/unhide excle sheet....
    By jaysakle in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-12-2013, 03:07 AM
  5. Split data into multiple sheets and to be hidden and password protected to unhide
    By anchuri_chaitanya in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2012, 11:36 PM
  6. Unhide hidden sheet?
    By evek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2010, 03:41 PM
  7. [SOLVED] Unhide hidden/protected worksheets
    By davegb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-01-2005, 10: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