Posts by fifijazz

    I can't stand those menus, either. How to get rid of them depends on the version of Windows you are running, I think. Try this:
    From the Start Menu, go to Settings>Taskbar & Start Menu. Uncheck the "Use Personalized Menus" box.


    try this:

    If I am understanding correctly what you are looking for, you can modify this:
    If Worksheets("SPORTELLI").Range("A1:A" & lngTargetRow).Find _
    (Worksheets("ANAGRAFE").Range("G" & lngSourceRow)) Is Nothing Then

    to this:
    If Worksheets("SPORTELLI").Range("A1:A" & lngTargetRow).Find _
    (Worksheets("ANAGRAFE").Range("G" & lngSourceRow)) Is Nothing _
    And Left(Worksheets("ANAGRAFE").Range("G" & lngSourceRow), 2) <> "95" Then

    If there are many conditions you want to apply then you may want to use a SELECT CASE structure.


    You can't directly reference cells in another worksheet when using a formula for conditional formatting. You could create a formula making one cell (say, $AA$1) on the datasheet equal to the value of the validation cell, then reference $AA$1. Or perhaps (untested) you can reference the validation cell if you name it and refer to it by it's range name.

    I saw solutions yesterday on the Word list to a similar problem. Perhaps one of these will work for yours as well:

    Suggestion1 was: "The easiest way is to make each 'link' a small VBScript to launch the document locally."

    suggestion2 was: "If your client wants this set as a policy, I'd recommend you ask them to
    administer this at a workstation level by correctly setting up their File
    Type association options.

    Depending on your operating system, you can toggle whether or not it is
    displayed in a browser by selecting "Tools | Folder Options... | File
    Types". Locate the "DOC" extension file type and click the Advanced button,
    then uncheck the "Browse in same window" option.

    This setting can more simply be distributed as a registry change by setting
    the following:
    @="Microsoft Word Document"

    As I mentioned before, this is operating system (and Word version)
    dependent. I think for Windows NT, for example, the registry change is
    slightly different. If a different version of Word is installed you may have
    to modify the reference to the Word.Document class (ie. "Word.Document.x"
    rather than "Word.Document.8" as I have in my example."