Search:

Type: Posts; User: u742884; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    9
    Views
    913

    Color Shading Options in Excel 2003

    In Excel 2003, when choosing colors for cell patterns, it only gives me the option of 40 colors. How do I get it to offer me the "More colors..." that you see when coloring shapes that brings up the...
  2. Replies
    1
    Views
    634

    Open files in separate windows

    Is there a way to open multiple Excel files in separate windows much like you can in Word--without having to manually open the Excel application multple times? (I am not referring to the ability to...
  3. Replies
    4
    Views
    303

    Try the Conditional Sum Wizard. It is an add-in...

    Try the Conditional Sum Wizard. It is an add-in that creates a Sum-If formula. Pretty self-explanatory
  4. Cannot find XLQUERY.XLA meessage upon file open

    I am getting the following message when I open my file:

    Cannot find XLQUERY.XLA!Register.DClick,which has been assigned to run each time [filename]worksheet name is opened. Continuing could cause...
  5. Replies
    4
    Views
    300

    Have you tried Conditional Formatting? Select...

    Have you tried Conditional Formatting? Select one of the cells with your formula. From the Format menu, choose Conditional Formatting.

    In Condition1, leave it as "Cell Value Is"; in the next...
  6. Replies
    0
    Views
    552

    Hidden HTML Forms getting in the way

    I have built a fairly simple spreadsheet where you copy/paste data from a website. With a macro, I copy down some formulas to clean up the pasted data and then the user copies from one of the...
  7. Replies
    6
    Views
    417

    Not displaying keyed text in an InputBox

    I have the following code where I prompt users for a password.

    PasswordCheck = InputBox("Only Planners may export plans. Please enter password.", "Merchanise Planning", "****** *******")

    Is...
  8. Thread: Date question

    by u742884
    Replies
    4
    Views
    301

    Barry's is a much cleaner version.

    Barry's is a much cleaner version.
  9. Locksheet is pretty inelegant: Sub LockSheet()...

    Locksheet is pretty inelegant:

    Sub LockSheet()
    ActiveSheet.Protect "mypassword"
    End Sub

    I will try the screen updating--can't hurt.

    Thanks.
  10. Thread: Date question

    by u742884
    Replies
    4
    Views
    301

    Here's a solution that does not require any code....

    Here's a solution that does not require any code.

    In b3 (or this can somewhere out of the way), key formula =month(b2). This will return the month # (1-12) of your date.

    In C1:N1, instead of...
  11. File takes a long time to open...sometimes

    I have a file with a ton of formulas so it takes a little while to open. However sometimes it takes a VERY long time to open. I have an auto_open sub:

    Sub auto_open()
    With Application
    ...
  12. Replies
    5
    Views
    320

    Oaktree, I saw your post after submitting...

    Oaktree,

    I saw your post after submitting mine. I read through the notes you referred to. I do not want to change any of their default settings so the which of these is correct:

    :-D I can...
  13. Replies
    5
    Views
    320

    I already have: Sub auto_open() With...

    I already have:

    Sub auto_open()
    With Application
    .Calculation = xlManual
    .CalculateBeforeSave = True
    End With
    [Some other stuff]

    End Sub()
  14. Replies
    5
    Views
    320

    Prevent Calculation On Open

    Is there a way to prevent a file from calculating when you open it?
  15. Replies
    4
    Views
    319

    That worked afterall. I think in my prior...

    That worked afterall. I think in my prior attempts, I left off the "\" in the ChDrive statement and that statement would error out. Since I wasn't sure if it was a real command since I had guessed...
  16. Replies
    4
    Views
    319

    Nope. Tried that.

    Nope. Tried that.
  17. Replies
    7
    Views
    298

    Your screen shot did not come through. About all...

    Your screen shot did not come through. About all I can make out is this:
    VLOOKUP($E$2:$F$2,$A$2:$C$2,3,FALSE)

    There is definitely a problem. You can only lookup off of one cell so the first...
  18. Replies
    4
    Views
    319

    Open file from a designated path

    I am trying to write code that prompts users to open files from a specific path. I am using GetOpenFilename, which works great except that the File-Open dialog box starts with your default path (or...
  19. Replies
    0
    Views
    221

    Calculation in a Read-Only file

    I have built a spreadsheet with TONS of Vlookup and Conditional formulas--so many that the status bar never shows "Ready" even following a complete calculation.

    To make it user-friendly, I have...
  20. Replies
    1
    Views
    292

    Here's some code I used once. I had my filename...

    Here's some code I used once. I had my filename in a range called CurrStore on workhsheet Settings, but if you already know your filename, you can probably just hardkey it with quotes or perhaps...
  21. Replies
    0
    Views
    210

    Ghost of Auto Recovery Pane

    When I run a macro that executes several queries to an Access database, the left side of my worksheet has a gray shading that looks like a ghost of the auto recovery pane. I cannot seem to make it...
  22. Replies
    1
    Views
    313

    VBA to query Access DB

    I have written/recorded code to pull selected fields from an Access table based on two criteria: BuyerNo and CalYear. This code works fine to pull for one BuyerNo where CalYear = 2006. It is...
  23. Replies
    3
    Views
    17,997

    I was thinking along those lines. I remember...

    I was thinking along those lines. I remember messing around to collect stock price info from Yahoo. Any idea what that suitable URL might be? Ever collected weather specifically?
  24. Replies
    3
    Views
    17,997

    Importing Weather Data into a spreadsheet

    I know this is an odd request, but I'm looking for a source that can automatically import weather data (high/low temp, precipitation). I work for a retailer. The spreadsheet records daily sales by...
  25. Replies
    2
    Views
    294

    Thanks. I knew it had to be something simple. ...

    Thanks. I knew it had to be something simple. Anyone with a little VBA knowledge could get past it, but I don't think my users know VBA exists.
Results 1 to 25 of 126
Page 1 of 6 1 2 3 4