+ Reply to Thread
Results 1 to 4 of 4

automating alt f8 select sheets with a button

Hybrid View

  1. #1
    Registered User
    Join Date
    02-01-2004
    Location
    New Hampshire
    MS-Off Ver
    2002, 2003
    Posts
    50

    automating alt f8 select sheets with a button

    i use alt f8, 'select sheets' to print my worksheets. my shortcut key is 'ctrl P'. Can i create a button to automate this? thank you Brian
    Brian

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    select sheets is a macro?

    So add code in the macro to print whatever sheets you want printed, and assign a keyboard shortcut.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-01-2004
    Location
    New Hampshire
    MS-Off Ver
    2002, 2003
    Posts
    50
    that's what i do now. i'm trying to put the code in a button that will pull up the select sheets form when i click it. I'm using a Control Toolbox command button. the code i'm trying to use is 'run.[module1]'. but it doesn't work. i would appreciate your help w/ the code.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    How much faster is it to push a button than to do Ctrl+P?

    Make a button from the Forms toolbar or an autoshape and assign the macro.

+ 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. Select Multiple Sheets In A Vb Code
    By Deci in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-15-2008, 11:21 AM
  2. Button /cell formula to automatically change sheets
    By mcqueen in forum Excel General
    Replies: 3
    Last Post: 02-25-2008, 01:44 PM
  3. Automating entries between sheets?
    By Johnz414 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2008, 02:42 AM
  4. Printing Multiple Sheets to One PDF file
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2007, 11:03 AM
  5. Button Detection
    By Warderbrad in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-05-2007, 04:26 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