Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

    Excel custom toolbar file location

    When a custom toolbar is created, where is this info stored?When I move to a new machine I always have to recreate my toolbars. It would be nice to just take the file with me.
  16. MigrantFirmWorker

    Excel VBA passwords

    Anybody know how to remove a password from a VBA module? I know the password. I just want to get rid of it.
  17. MigrantFirmWorker

    Hidden Objects in Layers

    I have had the same problem, and unfortunately, been unable to fix it consistently. Here are a few more possibilities: Groups have the same issues as components. You can move/delete the entities in a group and leave the 'group' entity behind. If it is unnamed, PartCleanUp will get it for...
  18. MigrantFirmWorker

    Hidden Objects in Layers

    As looslib pointed out, one source of these phantom entities is 'component' entities that get left behind when you move subcomponents to other layers. This is especially problematic when you split up a large assembly to different layers (say, for drawing purposes). When a component is...
Back
Top