+ Reply to Thread
Results 1 to 4 of 4

Using Code on a Hidden Worksheet

  1. #1
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Using Code on a Hidden Worksheet

    Greetings,
    I am trying to use the following macro. Worksheets("Master") is a hidden worksheet. I am getting a (Run-time error '1004: Select method of Range class failed) on the "lc.Select" line of code.
    Please Login or Register  to view this content.

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,737

    Re: Using Code on a Hidden Worksheet

    should works like that:
    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Using Code on a Hidden Worksheet

    You can only select a cell on the active sheet.
    Remove this line
    Please Login or Register  to view this content.
    & replace Selection with lc

  4. #4
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Using Code on a Hidden Worksheet

    KOKOSET and Fluff13,
    Thank you both for your help! Works great!!!

+ 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. VB code referencing a hidden worksheet error
    By rob_h in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2018, 03:52 AM
  2. [SOLVED] VB Code to show hidden Excel worksheet
    By tcrjmom in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-19-2014, 06:08 PM
  3. Code doesn't work when worksheet is hidden ?
    By SLIDE1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2012, 11:47 AM
  4. Code to save current worksheet and hidden worksheet
    By fusion007 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2011, 02:28 PM
  5. Hidden Worksheet code
    By incjourn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2011, 03:09 PM
  6. would this code find a worksheet that his hidden ?
    By spyrule in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2006, 10:56 PM
  7. [SOLVED] Code to access a hidden worksheet
    By sir Lancelot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-19-2005, 11:20 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