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 Chriss Miller 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. Benoni2

    Join Table Issues

    Hey, thanks so much you guys. It worked great. I was hoping to do it vb, but this is much faster, waist of time trying to program it the other way. thanks.
  2. Benoni2

    Join Table Issues

    as follow up, the colums don't line up well in my tables above, but I think you can get the idea. However, in the second table, it's important to note that agencyID is empty all the way down. The three columns apply to the last three column titles, Idnum, data1, and data2
  3. Benoni2

    Join Table Issues

    So here's a fun question I would really appreciate some help on. The actually problem uses more complex data, but if anyone can help me solve the problem below, either with a VBA example or through querries, I would really appreciate it. Okay, so: Two tables: Table 1 AgencyID Begin R End...
  4. Benoni2

    Protected Sheets, Shared Workbook & Spellcheck...

    I used the code: activesheet.unprotect ("password") activesheet.protect ("password") around my spell check macro code. All it did was run the macro, but if there were locked fields or protect parts of the workbook, it disabled the spell checker all together. This code above was slick because...
  5. Benoni2

    Excel: Spell Check while Sheet is locked

    got it. Thanks so much!
  6. Benoni2

    Excel: Spell Check while Sheet is locked

    Thanks for your patience. how do you reference the current worksheet?
  7. Benoni2

    Excel: Spell Check while Sheet is locked

    oops! I protect each worksheet differently on each page, I don't protect the workbook as a whole.
  8. Benoni2

    Excel: Spell Check while Sheet is locked

    Sub button_spellcheck() Is this what I need? It doesn't seem to be working for me in Excel 2003 ' button_spellcheck Macro ' Macro recorded 9/13/2005 by Benjamin Shier ' ' ActiveWorkbook.Unprotect Range("B15,B12,B9,B6").Select Range("B6").Activate Selection.CheckSpelling...
  9. Benoni2

    Excel: Spell Check while Sheet is locked

    So this is the code: Sub button_spellcheck() ' ' button_spellcheck Macro ' Macro recorded 9/13/2005 by Benjamin Shier ' ' Range("B15,B12,B9,B6").Select Range("B6").Activate Selection.CheckSpelling SpellLang:=1033 End Sub How do you write protect and unprotect in there? I tried...
  10. Benoni2

    Excel: Spell Check while Sheet is locked

    I have form in excel. I have locked most of the cells except for the four on the page that I want the user to type into. I then want them to be able to spell check those four cells using a button. Problem: Though this works fine when the sheet is not protected, as soon as I protect the sheet...
  11. Benoni2

    Excel: Cells as variables in VBA + Range Question

    Thanks for your help on this. This explanation helped me figure out a number of things I was working on. Thanks for your patience.
  12. Benoni2

    Excel: Cells as variables in VBA + Range Question

    Thanks! I will play aroun with that. That might take care of it just fine. For my personal knowledge, any idea on the other part of my question? How to name cells as variables in vba?
  13. Benoni2

    Excel: Cells as variables in VBA + Range Question

    I am trying to sort a page in excel. The trick is I want it to sort a range of cells that might change as new rows are added by the user. I am working off of the macro excel wrote when I started sorting. What I want to do is set the first cell of the range into a variable as well as the last...
  14. Benoni2

    Excel: New row at the end with a macro?

    I figured it out. Here is the code. Yesterday I think it was anotherhiggins who helped me with naming cells or a range of cells. This allowe me to select my named cell and insert a new record from there always adding it above my footer. the new row keeps my formatting from the above rows which...
  15. Benoni2

    Excel: New row at the end with a macro?

    What about something like what I thought anotherhiggins was suggesting, but a little different? Is there an easy way just to hide rows until required? So I have: A B C D Row1 Row2 Row3 Row4 Row5 (A5: Statement: =If B4 is blank, hide this row) Row6 (A6: Statement: =If B5 is...
  16. Benoni2

    Excel: New row at the end with a macro?

    What I would like to do is program a button that inserts a new row (record) after the last row on the form instead of immediately above the row.
  17. Benoni2

    Excel: New row at the end with a macro?

    Interesting. anotherhiggins has an interesting thought I might play with. But what I have is an activities sheet. It asks for the same information over and over again on each row, A through G. Right now I give them about enough rows to fill a printed page. When they get down to the last row...
  18. Benoni2

    Excel: New row at the end with a macro?

    I want a button that inserts a new row at the bottom when they have finished up with the available rows. So far though the insert button when recording a macro adds it above the selected record. Also, when repeated, it does the action off of the record that you origonally selected which pretty...
  19. Benoni2

    Excel: Very frustrating, top record of selection won't sort

    I think that is exactly what it was. It was thinking it was a header. I used a "follow my actions" macro and it wrote in there a "header:=xlGuess". So for whatever reason initially it seemed to work. but then after that it seemed to do it wrong. So now it is set to no. Thanks for the help.
  20. Benoni2

    Excel: Very frustrating, top record of selection won't sort

    Weird, I have a list of names in a column that I want to sort alphabetically. When I try to sort, it leaves the top value selected and sorts all those below it. I am working with vba taking the values elsewhere once sorted, but it should affect this part of it. Any idea why the top value remains...

Part and Inventory Search

Back
Top