Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross 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 MigrantFirmWorker

  1. MigrantFirmWorker

    Can't change borders of unlocked & unprotected cell

    Thanx for the assistance. I do have Freeze Panes on, but turning it off had no effect. There are no graphics on the sheet. I tried a variation of NomLaser's suggestion and saved the workbook in XML format then reopened it. That fixed the problem. The bad news is that I have some macros that...
  2. MigrantFirmWorker

    Can't change borders of unlocked & unprotected cell

    I think I've entered the twilight zone. I have a couple of cells on a worksheet that are unlocked and the worksheet is unprotected. I am unable to edit the borders. I can, however, edit the fonts, fill color, justification, etc. The "Format Cells" dialog also will not launch for these cells...
  3. MigrantFirmWorker

    Where are Excel preferences kept?

    At the risk of being greedy...what about Word, Powerpoint & Outlook? Chris ------------------------------------------------------------- "Don't be deceived. We're all temporary employees."
  4. MigrantFirmWorker

    Where are Excel preferences kept?

    thanx. Chris ------------------------------------------------------------- "Don't be deceived. We're all temporary employees."
  5. MigrantFirmWorker

    Where are Excel preferences kept?

    I have customized toolbars/icons and am now moving to a different computer. How do I transfer the customizations? Chris ------------------------------------------------------------- "Don't be deceived. We're all temporary employees."
  6. MigrantFirmWorker

    Selecting specific characters in a cell

    I appreciate the thought y'all have put into this. Unfortunately, it would appear that control-1 and clicking super(or sub)script is still the quickest means to this end... Maybe in the next upgrade... Thanks.
  7. MigrantFirmWorker

    Selecting specific characters in a cell

    I always had a nagging feeling that Microsoft omitted that canned feature from Excel for a reason.
  8. MigrantFirmWorker

    Selecting specific characters in a cell

    The character(s) could be at any position in the string. For instance, if my cell contains: "a generic string" I would like to be able to highlight any subset of characters and superscript them with one click of an icon. Going to the Format Cells form is tedious (although I'm very good at it...
  9. MigrantFirmWorker

    Selecting specific characters in a cell

    I would like to write icon-executed macros that will subscript and superscript the selected characters in a cell (like the canned functionality in Word & PP). I know how to manipulate the text. I just haven't been able to determine which characters are selected.
  10. MigrantFirmWorker

    Selecting specific characters in a cell

    Sorry. I neglected to mention that I am trying to do this with VBA.
  11. MigrantFirmWorker

    combining number formats

    I apologize if I have completely missed your point, but have you tried this format:? #,###;-#,###;;@
  12. MigrantFirmWorker

    Selecting specific characters in a cell

    I would like to apply formatting to the selected characters within a cell (as opposed to the entire cell). I have been unable to find a way to access the selected substring or even the cursor position. Any ideas?
  13. MigrantFirmWorker

    Crippling Strength in bending and Plastic Bending Theory

    The NASA Structures Manual (TM X-73305) presents a good method for bending crippling (section B4.4). Your choice of cutoff stress (Fcy, 1.1Fcy, etc) will determine how conservative your answer is. Using Fcy as a cutoff is safe, but not always accurate. The only truly accurate method is test...
  14. MigrantFirmWorker

    Why does my program stop writing after the first carriage return?

    (Fortran 77, Windows 2000) I am trying to write to a file: open (2, FILE='outputfile') write(2,*) 'stuff' write(2,*) 'more stuff' ... write(2,*) 'yet more stuff' The first line writes correctly. The following lines do nothing and I get no error or warning. I tried commenting out the first...

Part and Inventory Search