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

Recent content by farnye

  1. farnye

    password protected sheet

    Thanks for the advice. Would there be a better way to secure the file other than using excel's password?
  2. farnye

    password protected sheet

    I am creating some excel sheets for work and need to password protect them all. However I know there will be some people that will attempt to hack the file. Is there a way that I can open the spreadsheet and see if someone has turned ever off the protection.....(I am assuming that they turned...
  3. farnye

    Protecting the format and formulas of the sheet

    I have a similar question to this topic. When I go to adjust column widths, or add a column, I get the following error message "cannot shift objects off sheet". All of my protections are turn off. Is there another protection setting somewhere that someone placed on this sheet, or is this a...
  4. farnye

    Copying Sheets Between Workbooks

    I have two similar workbooks, 'A' and 'B'. The summary sheet in 'A' has formulas that reference back to the data sheet in 'A'. When I copy the summary sheet from 'A', into 'B', I would like the formulas to remain the same, but so they reference to the data sheet in 'B' insteadof 'A'. However...
  5. farnye

    Drainage Library Conversion

    Nevermind, it converts itself. I have other issues with my computer
  6. farnye

    Drainage Library Conversion

    Is there any way to convert my drainage library in ver. 7 to work in V8?
  7. farnye

    using hidden characters

    Thanks, those ideas both help.
  8. farnye

    using hidden characters

    In your example, is there any way that I can type in 15* in cell A7, vlookup would recognize it for other cells, but only 15 will be displayed in A7? I basically want to know if I can type out 15*, 15_, and only have the 15 show. Or is there a formating style that will only display the first 2...
  9. farnye

    using hidden characters

    Can I place a label in a cell, and have one of the characters remain hidden while viewed? My situation is as follows; On one sheet, I have a list of structures all labeled with numbers. On a seperate sheet, I type in the number I want, and use VLOOKUP to fill in the remaining results for each...
  10. farnye

    Running a macro through a command button

    Thanks, that solved my problem. (i had to many "End"s)
  11. farnye

    Running a macro through a command button

    I'm having problems getting this to work. Do you just use a simple run command in the command button code? I basically want to click a given button and the macro will start.
  12. farnye

    Using macro to add new sheets and change file name

    I got it to work now! It was something that was wrong with the workbook i was using. Thanks for your help!
  13. farnye

    Using macro to add new sheets and change file name

    I ran the script and it would only copy the sheets and then stop. However, if i break it into two different macros, i can get the copying and the renaming to each work seperatly.
  14. farnye

    Using macro to add new sheets and change file name

    Im trying to see if the following problem is even do-able. When doing traffic forecasting, i need to add/copy 2 new sheets in excel each time an additional intersection is started. By using the macro recorder, i have been successful in doing the following; -copying from 2 previous sheets to...
See more

Part and Inventory Search

Back
Top