+ Reply to Thread
Results 1 to 7 of 7

Print Active Worksheet if value of Cell C2 equals 1

  1. 10-09-2013, 08:36 AM #1
    mspeck
    mspeck is offline
    Registered User
    Join Date
    02-20-2012
    Location
    Fletcher, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Print Active Worksheet if value of Cell C2 equals 1

    Good morning,
    I'm looking to print the active worksheet if cell C2 value in the active sheet has a value of 1
    Can anyone help with this?
    Thanks in advance
    Reply With QuoteRegister To Reply
  2. 10-09-2013, 08:51 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,698

    Re: Print Active Worksheet if value of Cell C2 equals 1

    Try this:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 10-09-2013, 09:26 AM #3
    mspeck
    mspeck is offline
    Registered User
    Join Date
    02-20-2012
    Location
    Fletcher, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Print Active Worksheet if value of Cell C2 equals 1

    This example makes sense and I agree, should work. When I type a 1 in cell C2 and press enter, nothing happens
    Reply With QuoteRegister To Reply
  4. 10-09-2013, 09:38 AM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,698

    Re: Print Active Worksheet if value of Cell C2 equals 1

    This runs off a macro. Select Alt +F8 to see your macros. Select ams. You could link this to a command button, but If you want this to run when you change the value in C2, then you must load the vba in a worksheet change event.
    Reply With QuoteRegister To Reply
  5. 10-09-2013, 10:12 AM #5
    mspeck
    mspeck is offline
    Registered User
    Join Date
    02-20-2012
    Location
    Fletcher, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Print Active Worksheet if value of Cell C2 equals 1

    Here's what I have, What am I doing wrong.
    I can get this to work by running the macro, but not by entering a 1 in cell C2.
    In workbook code I have. . .
    Please Login or Register  to view this content.
    End Sub


    In sheet1 code I have. . .
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 10-09-2013, 10:46 AM #6
    mspeck
    mspeck is offline
    Registered User
    Join Date
    02-20-2012
    Location
    Fletcher, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Print Active Worksheet if value of Cell C2 equals 1

    Got it, thank you for your help.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 10-09-2013, 11:11 AM #7
    mspeck
    mspeck is offline
    Registered User
    Join Date
    02-20-2012
    Location
    Fletcher, Ohio
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Print Active Worksheet if value of Cell C2 equals 1

    Sorry,
    This was the code I used . . . 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Active cell equals print area, can only print all right now
    By Jeff up North in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2013, 12:34 PM
  2. Print Active Pages of a Worksheet
    By geepeeone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2009, 03:40 AM
  3. Print Active Worksheet
    By sysadmin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2007, 02:05 PM
  4. [SOLVED] CHANGE DEFAULT PRINT TO SELECTION INSTEAD OF ACTIVE WORKSHEET
    By FRED SMITH in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-27-2006, 02:45 PM
  5. Active cell counting in particular print page (one sheet having different print area)
    By ananthmca2004 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2005, 07:29 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1