+ Reply to Thread
Results 1 to 3 of 3

VBA to execute buttons on other sheets (print)

  1. #1
    Registered User
    Join Date
    03-08-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    16

    VBA to execute buttons on other sheets (print)

    I have a sheet where a button on sheet 1 that I would like to execute buttons on sheets 2 and 3. The buttons on sheets 2 and 3 are print buttons that print the set area as a pdf and save it to a specific folder with a specific title. Ive tried using the call feature but all it does is print sheet 1. Ive tried using the record feature with no luck. Any help would be appreciated. Ive attached a sample spreadsheet.
    Attached Files Attached Files

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,009

    Re: VBA to execute buttons on other sheets (print)

    .
    This works here :

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-08-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    16

    Re: VBA to execute buttons on other sheets (print)

    That worked. THANKS!!!!! Ive been trying to figure this out for the last three hours.

+ 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. Replies: 5
    Last Post: 04-22-2019, 08:10 AM
  2. [SOLVED] Print stack out as procedures execute?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2017, 07:10 PM
  3. Create buttons to print defined print areas
    By nwpassage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2015, 11:17 PM
  4. Execute code from auto generated buttons in a userform
    By Tellus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2008, 09:07 AM
  5. Replies: 2
    Last Post: 01-24-2007, 05:45 PM
  6. [SOLVED] How do I execute buttons in Excel using a voice command?
    By Rick Drabek in forum Excel General
    Replies: 0
    Last Post: 11-11-2005, 06:10 PM
  7. VBA buttons shift around when using Print/Print Preview
    By gunman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2005, 01:40 PM

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