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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by exceladdict

  1. exceladdict

    Problem with vba code for setting print area parameters.

    Thanks Skip, I added the code to adjust the margins as well and it works fine - it takes only about 4 seconds, which is what I expected. The recorded code was taking over a minute (even after I took out all the unnecessary stuff) and the main difference I see between your code and the recorded...
  2. exceladdict

    Problem with vba code for setting print area parameters.

    I have large excel 97 spreadsheet (Many formulas, Much formatting) that I have duplicated the Main Worksheet to about 25 other worksheets in the same workbook. (This gets utilized by about 6 other users via a shortcut to a template on the network). When I made the 25 identical copies it did not...
  3. exceladdict

    Hyperlink in excel 97 problem

    Thank you all - I was missing the obvious. Jim
  4. exceladdict

    Hyperlink in excel 97 problem

    Yes, I have NAMED the cell I want to goto on the other sheet in the workbook.
  5. exceladdict

    Hyperlink in excel 97 problem

    I have successfully used hyperlinks in my excel 97 spreadsheets (to both internet URL's and to call up another spreadsheet) but I am having trouble getting it to simply take me to a named cell in another sheet in the same workbook. Is there a special protocol for the formula? Is there a better /...
  6. exceladdict

    Want to create a pop-up window in excel 97

    Is there a form/control that allows a simple (information only) pop-up window to happen when the user enters a specific data into a cell? I am using a drop down list and one of the choices simply needs to evoke a warning to the user (then the user can escape or close it and move on). Thanks...
See more

Part and Inventory Search

Back
Top