+ Reply to Thread
Results 1 to 4 of 4

Hidding unhidding worksheet

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    7

    Cool Hidding unhidding worksheet

    Hi All,

    I am trying to figure out the correct codes for office 2010. I have found a website that gave me what I had wanted, but apparently these codes are for 2000 and 2003, and not applicable to office 2010. When I copied and paste their codes to my vba and saved, when I re-opened and tried to unhide my sheets, they prompt me a "Compile error in hidden module".

    This is their link with the codes that is exactly what I wanted: here

    Is anyone able to help me? It's urgent.

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Hidding unhidding worksheet

    Hi,

    Can you please upload your workbook so that I may take a look at the code in context?

    Thanks

  3. #3
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Hidding unhidding worksheet

    This code works perfectly in 2010 also. maybe you can upload your workbook so we can have a closer look at it.
    If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.

    I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.

  4. #4
    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: Hidding unhidding worksheet

    Hi,

    In the VBE Tools..References do any of the check boxes say 'Missing'.
    If so try using a different object of the same name or downloading it

    If not does http://support.microsoft.com/kb/307410 help?
    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.

+ 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. Problem Unhidding columns/rows in excel using VBA
    By Dan Hatola in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2006, 01:05 AM
  2. Unhidding sheets
    By starguy in forum Excel General
    Replies: 3
    Last Post: 07-22-2006, 10:50 AM
  3. [SOLVED] Very slow unhidding rows Excel 2000 SP3
    By rs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2006, 12:15 PM
  4. [SOLVED] Very slow unhidding rows Excel 2000 SP3
    By rs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-19-2006, 10:40 AM
  5. [SOLVED] hidding worksheet within a workbook
    By Colin2u in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2005, 06:05 PM

Tags for this Thread

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