Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: New position

    by billfinn
    Replies
    1
    Views
    1,209

    New position

    After a year as a temp (it was supposed to be 2 months) I am moving on, going back to Purchasing, this time at a Level ! Trauma Center.
    The project I did and re did and re did is now ready for prime...
  2. Re: MS Word 2010 document position when opening

    Yongle,
    Thanks very much for the response! I appreciate the info. Although I was hoping for something that would happen without intervention, SHIFT F5 (Did not know about that one!) is better than...
  3. MS Word 2010 document position when opening

    Good morning!
    This may be a really silly question, but is there an easy way to make Word always open a document where it was when last saved? I save documents while at the bottom of my document but...
  4. Re: "Office has detected a problem with this file. Editing it may harm your computer. Click for more details"

    I noticed that I fat fingered the code. It actually looks like this

    Private Sub Workbook_Open()Worksheets("Front End").Activate
    Application.GoTo Range("A1"), True
    ActiveWindow.VisibleRange(1,...
  5. "Office has detected a problem with this file. Editing it may harm your computer. Click for more details"

    Good afternoon,
    I have been working on projects using the only version supported here, 2000. To date I have had no issues working on it from my home PC running 2010 as long as I ran it in...
  6. Thread: ABC analysis

    by billfinn
    Replies
    3
    Views
    323

    Re: ABC analysis

    I always do ABC analysis using the total number of pieces used plus number of pieces sold multiplied by the cost of the item. then go through an exercise like this;
    Create a worksheet with the...
  7. Replies
    8
    Views
    427

    Re: Remove leading character

    Joe4,
    Thanks much for your reply!
    I tried the LEFT command and it gave me the =. I tried Text to columns and it caused several formulas that were working OK to stop working. I truly don't have...
  8. Replies
    8
    Views
    427

    Re: Remove leading character

    Update - I tried copying a dozen or so formulas into a word doc, then copy pasted them back in my sheet and no more leading'. Copy Pasting into a different spreadsheet doesn't work. I at least np...
  9. Replies
    8
    Views
    427

    Re: Remove leading character

    JoeMo,
    Here are some examples. Interestingly when I paste them here there is no leading '. Maybe a clue of some kind. I appreciate any suggestions you can offer

    <tbody>
    =IF(AND('Quick...
  10. Replies
    8
    Views
    427

    Re: Remove leading character

    SHG, I tried using Replace - Replace comes back with a message - Moscosoft Excel cannot find a match
    Thanks much for your response!
    Bill
  11. Replies
    8
    Views
    427

    Remove leading character

    Good afternoon!
    I pulled several thousand formulas into a spreadsheet and brought them in with the ' front of the =. Now that I have modified the formulas and am ready to calculate them all I need...
  12. Re: Prevent Save and Save as unless using Macro Button

    Offthelip,
    I had to change the new sub from inhibitsave to preventsave as there was a conflict with the Public inhibitsave but it works great!
    This one is now ready to release to the users. ...
  13. Re: Prevent Save and Save as unless using Macro Button

    Offthelip,
    I did notice one odd thing. When I did the save using the macro button, I was then able to use Save or Save As with no issue. If I exited and reopened the workbook it was once again...
  14. Re: Prevent Save and Save as unless using Macro Button

    Offthelip,
    Thanks very much! That code works exactly as I needed it to.
    This gives me confidence that no one is going to screw up the main project file, they can only save using the macro...
  15. Re: Prevent Save and Save as unless using Macro Button

    Offthelip,
    Thanks much for the response! I'm working out where to place each of these little subs in my macro and then I will let you know how it works. Might be tomorrow if people keep bugging...
  16. Prevent Save and Save as unless using Macro Button

    Good afternoon!
    I am trying to set up a Workbook so that using Save or Save As is disabled but Macro buttons that do specific Save As commands are allowed.
    I have the following code which works...
  17. Re: Formula to input margin % and then have sales price adjusted

    Assuming your data is in a worksheet with column headers and is in column A, in B2 enter 1+ the percentage of change, ie: if you are increasing by 12 percent enter 1.12.
    Select the cell with your...
  18. Re: Excel 2000 Macro to prevent moving beyond a cell without making a choice from Dropdown

    RESOLVED
    Dante,
    Thanks very much for your response!
    I just opened my browser to close this one out as I came up with a solution, realizing that all I needed to do was have two conditions that had...
  19. Excel 2000 Macro to prevent moving beyond a cell without making a choice from Dropdown

    Good morning!
    I am trying to make it mandatory for one specific cell to have a value before the user can move on. I came up with the following macro that works fine if the user happens to scroll to...
  20. Replies
    9
    Views
    446

    Re: Macro not incrementing

    Fluff,
    I had already changed the first line you referenced and deleted the second line you referenced. I didn't catch the third line you referenced. I will get that one taken care of this...
  21. Replies
    9
    Views
    446

    Re: Macro not incrementing

    StephenCrump,
    I went back and tried your suggestion again and it worked! Not sure what I did wrong last time I tried it but thanks much for getting me to try again!
    Thanks much,
    Bill
    RESOLVED!!
  22. Replies
    9
    Views
    446

    Re: Macro not incrementing

    DaveRunt,
    Thanks very much for your response.
    For that particular line of code "B" is correct as that is for the date. In this macro I populate columns A,B, C and D with Version, Date, Name, and...
  23. Replies
    9
    Views
    446

    Re: Macro not incrementing

    Stephen,
    Thanks for the response. I have tried them both ways with no help for the original issue.
    thanks,
    Bill
  24. Replies
    9
    Views
    446

    Macro not incrementing

    Good morning!
    My apologies for the somewhat cryptic Title but I was unsure just how to phrase this
    This macro saves a version of a file in a specific folder and names it filename - version -...
  25. Re: Excel 2000 VBA feeding a value to a formula

    Yeah, just figured that out. Apparently I was looking at Variable limits for something other than VBA. Must be Christmas Fever...
    Thanks again Fluff.
    Bill
Results 1 to 25 of 114
Page 1 of 5 1 2 3 4