Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    5
    Views
    437

    Thanks for the idea, Maud. However, I am dealing...

    Thanks for the idea, Maud. However, I am dealing with (example) 332 comments in a 29 x 452-cell table... I think I might perish before I got through just this one worksheet using the screen tips...
  2. Replies
    5
    Views
    437

    Wandering cell comments in Excel 2007

    :mad:
    I'm pretty savvy about wrangling cell comments back to the desired positions by using VBA procs, but I want a software fix, not a workaround from VBA...
    I rely heavily upon cell comments....
  3. I'm going to try your sequence. This is very...

    I'm going to try your sequence. This is very encouraging news!
    Many thanks, Joe :cheers:
  4. Thank you, BruceR -- by George, I don't know how...

    Thank you, BruceR -- by George, I don't know how I could ever have missed the link at the end of the Patch Watch column... :rolleyes:
  5. How to deal with a large backlog of "wait" patches -- Patch Watch

    Now that I seem to have resolved my old problem, the inability to install SP1 for Windows 7 Home Premium, I want to catch up with a slew of old patches listed on Windows Update over a 2-3-year...
  6. Replies
    25
    Views
    7,139

    ! ! Patch Watch List in a *.csv file ! !

    Greetings, RG,
    Great idea! Especially the part about the universality of *.csv.
    Regrettably, if I'm not mistaken the cells in a *.csv file won't hold any cell comments. Many of Susan's...
  7. Replies
    43
    Views
    8,285

    sbraddock: Outstanding analogy. Thanks.

    sbraddock:
    Outstanding analogy.
    Thanks.
  8. Roderunner, The passwords on this PC have been...

    Roderunner,
    The passwords on this PC have been set up that way from the day that I got it; please note recent additional information, 2011-05-28 17:52 EDT.
    I'm interested, though, in your first...
  9. Additional information: 1) My hasty act of...

    Additional information:
    1) My hasty act of stupidity occurred almost a year ago. Thus, there have been countless additions/tweaks/deletions to the contents of the HD since then.
    2) I have copied...
  10. Replies
    36
    Views
    18,267

    Yes... both administrator accounts are on...

    Yes... both administrator accounts are on [separate] passwords.
  11. Replies
    36
    Views
    18,267

    tfspry: Well, the user might have known my...

    tfspry:
    Well, the user might have known my wife's account password -- I made both her and myself administrators on this PC. I'm not sure, but that leak perhaps lasted long enough for the initial...
  12. How to undo botched edits of access control

    In an un-smart move to make sure that my laptop running Win 7 Home Premium would be protected from tinkering by teenage children, I started changing Allow and Deny permissions for folders and files...
  13. Replies
    36
    Views
    18,267

    Inside-family hacking job -- how to block

    Any suggestions as to how to block a rogue user, who doesn't have administrator rights and who is supposedly restricted by Parental Controls to time limits and selected applications/web sites, from...
  14. Jan Karel: Great article! Most informative,...

    Jan Karel:
    Great article! Most informative, and I was able to get my project working.
    Thanks a lot.
    jes
  15. I have a list of names and need one worksheet for...

    I have a list of names and need one worksheet for each of the names. The "ANC" worksheet is what I would like to use as the "template". Is there an easy/fast way to create new worksheets in the...
  16. Replies
    4
    Views
    476

    Toolbar customizations are stored in a file with...

    Toolbar customizations are stored in a file with extension .xlb, usually found in C:\Documents and Settings\<username>\Application Data\Microsoft\Excel. You can open this file (by double-clicking it...
  17. Client has a financial model (Excel 2003 file)...

    Client has a financial model (Excel 2003 file) containing approx. 40 worksheets. There is a custom command bar, "Viewing Mode", which client uses with this model. Parts of the VBA code in the model...
  18. Hans: ...That's good news. Thanks very much!...

    Hans: ...That's good news. Thanks very much!
    jes
  19. Please help me to verify these tentative...

    Please help me to verify these tentative observations, when debugging an app in MS Excel (2003) that has several UserForms:

    1. When retrieving a value from a {text box, combo box, list box}, the...
  20. Replies
    9
    Views
    851

    Recently my color palette has changed and I get...

    Recently my color palette has changed and I get "muddy" colors instead of the normal ones. THey'll change for no reason I know. Also some workbooks come in with unusual colors I cannot change back....
  21. Replies
    8
    Views
    1,182

    Does this help:...

    Does this help:
    http://msdn.microsoft.com/en-us/library/aa155610.aspx

    Steve
    Steve: Thank you for pointing me to that reference -- it's a keeper! In the current matter, though, I want something...
  22. Replies
    8
    Views
    1,182

    To expand on Rory's comments, which is better...

    To expand on Rory's comments, which is better will depend on what you are using it for.

    If you want to validate the entry, you can validate the entire entry in the AfterUpdate event, but if you...
  23. Replies
    8
    Views
    1,182

    If you use the Change event of a textbox it...

    If you use the Change event of a textbox it occurs whenever the textbox changes - i.e. it fires for each character you type in the textbox. The AfterUpdate event is triggered once as you leave the...
  24. Thread: Name Ranges

    by JohnS0603
    Replies
    6
    Views
    559

    Hi, I'd like to name a range but not have it...

    Hi,
    I'd like to name a range but not have it specifc to a particular sheet. I'm using version 2003. Right now if I go to the Name/Define option, it always asks for a sheet name and it will always...
  25. Replies
    8
    Views
    1,182

    A client has a model in Excel2003 with fifteen...

    A client has a model in Excel2003 with fifteen userforms. For the text boxes and combo boxes in those userforms, some of them have the _Change event, and others have the _AfterUpdate event.

    As...
Results 1 to 25 of 84
Page 1 of 4 1 2 3 4