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. wotgoesup

    MS Excel is very very slow in deleting content! Any work around that?

    I was having long delays deleting rows from, and when changing data in a large sheet that had mainly conditional lookups. (e.g. =IF(M135=1,S135/(VLOOKUP(Z135,swdctgt,4,0)),0) ). Everytime I changed one cell or deleted/inserted a row, it seemd to take 40 - 50 secs. In my case, the issue was...
  2. wotgoesup

    How can I change the colors used for the drop downs in autofilter?

    OK so I can't change the "arrow" directly. [sad] Is there VBA code that I could use to change the color of the heading if it's a filtered col?
  3. wotgoesup

    How can I change the colors used for the drop downs in autofilter?

    I have a major spreadsheet with over 60 cols of data. I have a freeze panes set at cell D3, and users scroll across, often filtering on 4 or more cols. They often zoom to 75%, and hide some cols to view more of what they want on the one screen. ISSUE : not easy to tell which cols have filters...
  4. wotgoesup

    Access - Multi level search query

    Chad, thanks for taking the time to look at this. Currently I only have a spreadsheet! There are around 3000 server/app combinations, and typically I manually drill down usually 3, sometimes 4 levels. I'd really like to build a hierarchical view. I thought I would need one table keyed by server...
  5. wotgoesup

    Access - Multi level search query

    My problem: I have a table with application ID's and the servers on which they reside, and an index for server to app. Both are many to many relationships. I need to drill down until I have all apps / servers involved or connected to one app or one server e.g. serverA has to be relocated...
  6. wotgoesup

    OUTLOOK- turn of reminders in a specific calendar?

    Thanks, Sawedoff. I'm running 2003. The problem is that the option you suggested applies to all calendars, so when I turn off the reminders in the shared calendar, it also affects my regular calendar. I want the reminders to popup in my calendar (where all conf calls include me), but to...
  7. wotgoesup

    Excel_VBA to prompt for me to type in filename

    Go into the VBA screen, and type "msgbox" into the search help.
  8. wotgoesup

    OUTLOOK- turn of reminders in a specific calendar?

    Our group shares a conference call line. To avoid having to ask around to find out if it's being used at a specific time, I set up a Public Folder calendar, and added each group member as an author. Each of us then added a rule to our Outlook so that when we create a meeting using the conference...
  9. wotgoesup

    OUTLOOK Calendars - Stop reminders going to "uninvited" group members?

    Our group shares a conference call line. To avoid having to ask around to find out if it's being used at a specific time, I set up a Public Folder calendar, and added each group member as an author. Each of us then added a rule to our Outlook so that when we create a meeting, a copy is written...
  10. wotgoesup

    Float a command button to appear on all sheets?

    I've had great answers in the past, so let's try this one: I have 4 sheets in a workbook, named A - D. I want to have 4 buttons, each with a macro that activates a specific sheet, and selects a specific cell. I know that my users can click on say, sheet A, but I want them to see a button on...
  11. wotgoesup

    need to specify the vertical "indent" for "autofit" on ROW

    I have a VLOOKUP that pulls text into a "wrapped" text cell. I want to specify a gap between the last line of text and the bottom border of these cells ( to space things out) Horizontally I can use the indent, but is there a vertical equivalent?
  12. wotgoesup

    How to send FROM a Distribution list

    I have a small DL and want to send emails FROM our group, not specifically from me. I selected "from" in the View menu, but when I add the DL, I get an error, even though I own the DL. How can any of us in the DL send emails FROM the DL? Thanks
  13. wotgoesup

    How to tell if sheet has been changed

    I want to put today's date in cell E3 if the user has changed anything. I thought I could use Worksheet_Change, and I coded that as: Range("e3").Select ActiveCell.Value = Format(Now, "dd-mmm") This works, but then the active cell is E3, and the user obviously wants to be in the cell...
  14. wotgoesup

    Excel -- stop execution of workbook_open ?

    Ron - Thanks for the idea, but there's another condition: The manager may not want the updated timesheets - he may want what was there last time he opened it. So I have a msgbox that asks if you want to update the sheets. If I link, I think it will update every time it's opened. [ponder]
  15. wotgoesup

    msg "too many edits in the document" in WORD

    Do you have enough free space for your temp file (10Gb +) ? http://support.microsoft.com/kb/224029
  16. wotgoesup

    copying sheets from 3 workbooks into 1 - Workbook_Open

    Mmm I wish I'd thought of that before I started! It's only 4 people, so I'm not sure it's worth a rewrite. Thanks again for your help [smile]
  17. wotgoesup

    Excel -- stop execution of workbook_open ?

    I have timesheets with a Workbook_Open macro that asks if it's a new week. If it is, it adds 7 days to a cell and uses that as part of the file name for the save. Works fine, each member of the team has their own wkbk, and the date is the same in each. I copy those 3 into one workbook with a...
  18. wotgoesup

    copying sheets from 3 workbooks into 1 - Workbook_Open

    Thanks, guys! I now am able to copy the 3 time sheets into 1 summary wkbk. Can anyone help me with the second question? The open macro for each time sheet gets executed when the VBA in the summary wkbk is run. i.e. the summary VBA triggers the "new week?" msgbox in each timesheet it opens...
  19. wotgoesup

    copying sheets from 3 workbooks into 1 - Workbook_Open

    Hi, Skip, here's the code Private Sub Workbook_Open() a = MsgBox("Start a New Week?", vbYesNo) If a = vbYes Then Dim hammer As String Dim enextdate As Date Dim efiletxt As String Range("E3").Select ecurrdate = ActiveCell enextdate = DateAdd("d", 7...
  20. wotgoesup

    copying sheets from 3 workbooks into 1 - Workbook_Open

    I need help: 3 staff each update their own "timesheet", which has a Workbook_Open macro that asks if it's a new week. If it is, it adds 7 days to a cell and uses that as part of the file name for the save. Works fine, each member of the team has their own wkbk, and the date is the same in each...

Part and Inventory Search

Back
Top