Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. majopa

    Select Sheets Dialog Box

    Lack of knowledge/experience.
  2. majopa

    Select Sheets Dialog Box

    I did. I was hoping for a button on the dialog box where the user selected the sheets and pressed 'OK' or 'Cancel'.
  3. majopa

    Select Sheets Dialog Box

    Thanks. Now that I have the code I have two questions. Where do I put the code and how does the user access it?
  4. majopa

    Select Sheets Dialog Box

    I was hoping that someone may be able to help me add a 'Select All' button to the dialog box that allows the user to select the sheets to print. Thank you in advance.
  5. majopa

    Select Sheets Dialog Box

    I couldn't even get that far so I don't have anything to post. It is not a big deal and I am willing to live with it as is. Thank you again.
  6. majopa

    Select Sheets Dialog Box

    Skip - You have been such a huge help. Unfortunately, I am far from a programmer. I tried to do as you said and I have been unsuccessful. I am typically not the type to give up, but since I am so inexperienced, I feel I must. I thank you for your help on this and I will have to live with it...
  7. majopa

    Select Sheets Dialog Box

    Skip - That is perfect. Any way to add a 'Select All'? Thanks
  8. majopa

    Select Sheets Dialog Box

    Skip - That is much better. The only other issue that remains is when you are selecting the sheets to print is the sheet with the design of the dialog box is showing. Is there anyway to remove that as it may be confusing to the user. The other 'nice to have' would be an option to 'Select All'...
  9. majopa

    Select Sheets Dialog Box

    Before I commented this line out the last worksheet, which I never selected, printed with the selected sheets. Now, although the last worksheet no longer prints out. Instead, a new 'Dialog' with a number (e.g. 'Dialog 18') worksheet prints out. This worksheet is nothing more than a design...
  10. majopa

    Select Sheets Dialog Box

    Thank you Skip. Although this prevented the last sheet from being printed, it was replaced with another sheet. It also shows a 'Form' design page worksheet that shows the 'Select sheets to print' dialog box - this is the extra sheet that is printed. Any thoughts? Thanks again.
  11. majopa

    Select Sheets Dialog Box

    I used the code from http://www.j-walk.com/ss/excel/tips/tip48.htm and incorporated a couple of modifications that I also found online. All of this has left me with an issue that I am sure requires only a simple fix, but that I am unable to correct. The problem is the last worksheet prints...

Part and Inventory Search

Back
Top