+ Reply to Thread
Results 1 to 6 of 6

Unable to Run VBA

  1. #1
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Unable to Run VBA

    Hello

    I am unable to run the VBA if my sheet is hided.

    Kindly suggest.

    Regards
    Vinay

  2. #2
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Unable to Run VBA

    Can you please provide some additional details?
    Are you trying to run a macro against a sheet that is hidden? Trying to kick off a macro that is triggered by a button on a hidden sheet?
    There are some extremely talented people here who I'm sure can help - the more details you can give them, the better!

  3. #3
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: Unable to Run VBA

    Yes,

    I am trying to run a macro against a sheet that is hidden and using a Button in sheet which not hidden.

  4. #4
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Unable to Run VBA

    To unhide before running: Right click on the sheet names at the bottom of the page, select UNHIDE, then pick the right sheet.
    To unhide in the code: at the beginning of your macro, add
    Please Login or Register  to view this content.
    then to rehide it,
    Please Login or Register  to view this content.
    If you don't want any of this to be seen by the users, add this to the top of your macro:
    Please Login or Register  to view this content.
    and this to the end
    Please Login or Register  to view this content.
    -- this will prevent the screen from updating while the macro runs

    Hope this helps!

  5. #5
    Forum Contributor
    Join Date
    12-20-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007 & Excel 2010
    Posts
    115

    Re: Unable to Run VBA

    It is working...

  6. #6
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Unable to Run VBA

    That's great!

    Don't forget to mark this thread as SOLVED when you have a chance.

+ 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. Unable to fil a column
    By Joseph Stewart in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-13-2013, 12:18 PM
  2. Replies: 3
    Last Post: 11-08-2012, 07:25 PM
  3. Unable to open one particular .xls
    By jaju.hitesh in forum Excel General
    Replies: 3
    Last Post: 04-25-2012, 02:32 AM
  4. [SOLVED] Unable To Record
    By Help\(less\) Desk in forum Excel General
    Replies: 1
    Last Post: 06-23-2006, 03:25 PM
  5. Unable to use add-ins
    By DavidH in forum Excel General
    Replies: 0
    Last Post: 04-29-2006, 08: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1