Search results for query: *

Hi, Does anyone know how to do this??? If I have more than one line in the query window it complains. Thanks, Chris

Hi, Is there anyway you can make ctrl D calculate a workbook without having application.onkey in a macro somewhere??? I've searched through all the xla addins and the workbook modules for onkey and cannot find one. Any ideas? Thanks, Chris

Hi, If I change one cell in a range, does anything such as a vlookup referencing that range become dirty? Judging by calc times of a sheet this looks to be the case. Can anyone confirm? Thanks, Chris

Hi, I'd like to open a file with disabled macros, but I don't know how to. (I have tried increasing the security settings to medium but I am not asked whether I want to open the file without macros). How do I disable macros whilst opening the file (I've tried holding down shift whilst opening...

Hi, When I save a sheet down on my PC on the c:\ drive and then give the sheet to someone else, the UDFs that were just =Myfunc("Apples") turn into =\\mycomputerName\directory\functions.xla!myfunc("apples"). Any ideas why this happens and it could be prevented? Thanks, Chris

Hi, I have an audigy and a labtec microphone (which doesn't seem to have a mute button). I put the microphone into the socket today (both pink) and when I load volume control I can check/uncheck the microphone mute in "play control", but I cannot uncheck mute in the "recording control". Any...

Hi, Why does this happen you hit f9 or shift f9 or ctrl alt f9 and some cells don't calculate (note these are UDFs) and then when I f2 enter it calculates. Is the calc tree messed up? I'm currently going through the sheet replacing = with = to see if that helps...

Hi, I have a now() in one cell and a hardcoded date in another. I minus the two cells from each other in a result cell. Each time I calculate the result cell using f2 enter the cell with now() does not calculate. I thought that was the point of it being volatile, it will keep calculating ever...

Hi, Whats the best/easiest way to find the calc order of a sheet. I'm using Excel 2002 and want to make sure that the sheets are in the right order... Thanks, Chris

Hi, In Excel there are some hyperlinks on a worksheet. How do I simulate a click on one of these hyperlinks? There is an event based on it that I want to run. Thanks, Chris

Hi, I had some .avi files in some folders. Whenever I opened up that folder in explorer explorer crashes (Nb I have detail view as opposed to thumbnail...). I deleted the avi file and no longer have explorer crashing. Any ideas what the problem is? Thanks, Chris

Hi, Is there anyway to send an email in outlook forcing the receipient to only be able to reply all? Thanks, Chris

Hi, In Excel 2002 I can't find the option to toggle between read and readonly. Has it been removed? Or do you know where it is? Thanks in advance, Chris

Hi in Excel 2002. Where is the personal.xls file normally kept. How can you point it to another personal.xls file? Thanks, Chris

Can you use application.run to run a function in a dll? Thanks, Chris

Hi, I load an Xla built by someone else and then there are compile errors becauase that readonly xla cannot find the correct dll. But when I uncheck the reference and then do a search for it I find it. How is this possible? Thanks, Chris

Hi, I want to use Index(A1, 2,1) where A1 contains the name of the range I want to do the index lookup on. How do I do this? Thanks in advance, Chris

Hi, I have a missing addin. How do I tell which location it is trying to find it (The dialogue width is not big enough for me to see where it is pointing to) Thanks, Chris

Hi, Why can I not use the below code: counter = argA + argB range("A1").formula = "=if(autorun, " & counter & ", Hello)" I get the "application-definted or object-defined error" debug window. But I can do range("A1").formula = "=if(autorun, 55 , Hello)" fine. Why can't I do the...

Hi, Once you do: application.ontime Date + Time + 0.1, "MyRoutine" Is there any way to tell when MyRoutine will run? I mean without trying to work out when it was run from the ontime? E.g. some sort of command? (Something is happening in the background I guess some sort of thread is kicked...