Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Unhide Hidden VB Modules

  1. #1
    Join Date
    12th March 2003
    Posts
    66

    Unhide Hidden VB Modules

    I've hidden my VB modules because they refer to the password that protects all of the worksheets. I used the method below as described by Dave. NOW, my question is how do I UNHIDE them. I've gone to Tools>VBA RULESProperties - Protection. I can see the password boxes with ******** in them. I can change that but nothing happens. I still can see all the modules with my code in them. LOL HELP !

    Thank you for you help.
    cmark


    Originally Posted by Dave Hawley
    ...are you aware you can also Lock the VBE from showing Modules etc? While in the VBE go to [b]Tools>VBAProject Properties - Protection[\b]. The protection will take effect after saving, closing and re-opening the Workbook.
    Last edited by cmark; November 30th, 2005 at 05:15.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    22nd April 2003
    Location
    Virginia, USA
    Posts
    5,035

    Re: Unhide Hidden VB Modules

    When you entered the password, did you also check the "Lock Project for Viewing" option?
    Best Regards,
    Tom
    ---------------------------
    Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

  3. #3
    Join Date
    12th March 2003
    Posts
    66

    Re: Unhide Hidden VB Modules

    Yes, I checked the box that says, " Lock project for viewing" on the Protection Tab.

    I've since tried to uncheck and re-enter the password, but that didn't unhide the modules.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,684

    Re: Unhide Hidden VB Modules

    cmark
    Works ok for me i do this a lot - can You re test step by step following Dave instructions and post back

    Remember You must save and exits Excel; then re-open for this change to take effect

    jiuk

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    22nd April 2003
    Location
    Virginia, USA
    Posts
    5,035

    Re: Unhide Hidden VB Modules

    Same results as Jack. Works for me.
    Best Regards,
    Tom
    ---------------------------
    Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

  6. #6
    Join Date
    12th March 2003
    Posts
    66

    Re: Unhide Hidden VB Modules

    Jack in UK and Thomach,

    Thank you for your help, but I'm still not able to see any modules in the workbook by go through VB Editor. I've tried while in the VBE go to Tools>VBAProject Properties - Protection, then checking and unckecking the box that says (in VB Editor, Tools > RULES Properties, the password box opens, I type in the password, and RULES Project - Properties box opens, there is a General tab and a Protection tab, I select Protection, I uncheck the box that says "Lock project for viewing", below it are two fields filled with *********. I've tried entering the password in one and then both. Nothing happens. I tried entering the password and saving the file and closing it and then reopening it. Still nothing except the following lets me see the modules again.

    I can see and edit one module at a time by opening Tools in the workbook, > macro, and selecting a macro from the dropdown list and clicking Edit.

    So the modules are hidden and the end user CAN STILL see and edit the specific macro, even though I didn't want them to see it or edit.

    I've tried every combination I can think of to be able to see the modules again. And, yes, before you ask I know the password is the same as the one I originally used. Good thought, though. Thanks Cmark

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Hide/Unhide Rows On Hidden Sheet
    By dtlay in forum EXCEL HELP
    Replies: 3
    Last Post: May 28th, 2008, 11:13
  2. Unhide Last Hidden Row In Column
    By CoraLee in forum EXCEL HELP
    Replies: 1
    Last Post: February 22nd, 2008, 13:35
  3. Unhide Hidden Rows
    By TALLTRVLER in forum EXCEL HELP
    Replies: 5
    Last Post: August 31st, 2007, 09:33
  4. Unhide One Row From Many Hidden Rows
    By simmon in forum EXCEL HELP
    Replies: 7
    Last Post: June 8th, 2007, 10:19
  5. Unhide a Hidden Workbook
    By 4Given in forum EXCEL HELP
    Replies: 3
    Last Post: August 14th, 2004, 23:30

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
  •  
porno