Recent content by handlewithcare535

Many thanks guys, I'll try this now. I've also just been asked if it's possible to turn the row red if the task is overdue. This is simple for the 'date due' cell, but can I do it for the whole row? Thanks hwc535

I'm trying to make a spreadsheet so that everytime I add a new row, the background is a different colour. I want two colours that alternate as you go down the rows so that it is easier to read. Is there a way to do this automatically when I type in text? I have the following code, which...

Thanks a lot PHV, this worked a treat!

I am trying to open a word file from a command button in excel. I've been trying to use: filenam = "\filename.doc" loc = activeworkbook.path helpfil = loc & filenam RetVal = Shell("C:\Program files\Microsoft Office\Winword.exe " & helpfil, vb normal focus) However, this does not work. It...

it's the c:\folder\file.xls format

Sorry, yes I can see how that would make no sense now! What I want to do is: I have a bunch of excel files, all linked by command buttons which open another file when clicked. This works fine. However, I want to email these excel files to other people and for them to be able to use them as...

I am looking to have a command button which, when pressed, opens another excel file. This is simple enough, but I can't work out how to make this work when the file location is different. I.e. I want to be able to email these files to other users and for the code to still work. Is there a way...

Thanks, I've managed to do that now!! My customer is getting even harder to pleaase now though! Any ideas on how to filter the comboboxes depending on selections already made on the form. e.g. If I were to have two comboboxes on a form, first name and last name for instance. If I selected...

I am trying to make a query which involves having the option of typing in numerous parameters (sort of like a search function), but I can't work out how to stop it from bringing back only empty fields if I don't type in a value for one of the parameters. For example, one of the parameters is ID...