Recent content by AliJay

Thank you both for your help, you are both STARS. Sorry for not replying earlier but I'm not getting the e-mail notifications. AJ

Thank you so much - stars to you both. Just finally: There is a list of Macros (TOOLS --> MACROS etc.) associated with the worksheet I am working on but the Private Sub is not on that list whereas any other Sub I have written is. So how do I go about activating the Private Sub? Just...

Hi Guys, I wonder if someone could help me with what should be a VERY simple solution but is beyond me! My problem is similar to some other questions posted here but none quite match. Using Excel I want to be able to select a random cell using the mouse. I then want to run a macro which...

Hi all, Is there a way using a macro in Excel that I can change my computer's audio volume output? I suppose I am looking for a system volume property that I can change. Any help would be very much appreciated. PS I use XP and Excel 2003 Cheers AJ

Hi Glenn, Thanks so much for taking the time to help me out. Please accept a star!! :-) I also found this web page on my travels that might help someone else out too http://www.winxptutor.com/schsd.htm

Hi, I run Windows XP. Is there a way of timing the computer to shut down at a certain time (say 9PM) when I am away from the computer. I use my computer to monitor data and want the computer to automatically turn off when it is done. I am thinking it could be a scheduled event but cannot see...

Hi Glenn - you're right it's not the sort of thing that you solve by chance!! :-) I don't post much here but ..... my first EVER star Waaa Hay!!!

Well after much deliberation I got onto MS themselves and they were very efficient ... they came up with this which worked ... 1. Click Start, and then click Run. 2. In the Open dialog box, type regedit, and then click OK. 3. In Registry Editor, locate and then click one of the following...

Hi Guys, I have just "upgraded" from MS Office XP Ver. 2002 to MS Office 2003 on a machine that uses XP. In one Excel spreadsheet there is a hyperlink to a .wav file on my hard drive. In the 2003 version when the hyperlink is activated a Microsoft Excel "warning" pops up saying "Hyperlinks can...

Thanks for taking the time to write kmc - I think we all will have learned a tremendous amount from your post. You're a star! There are two main programs using the RAM - one is mcshield.exe which (I find) is part of McAfee's anti virus suite and constantly scans when online for Viruses, Trojans...

It is excel - I'll give it a go. Thanks again - all the best John

Thanks Nelviticus - Please have a star. It looks like it's the "badly written macros" then! Doh - I wrote them myslef :-) Oh well. I'm not sure how to write good ones. I think that's a topic for another forum. Just to clarify though - there is no process or software that can clear the CPU...

Hi - sorry of I confused you. I have the Excel workbook connected to a datasource on the web via something called DDE. It means that as the values change it updates in the Excel spreadsheet itself. I have tried Autosave but the CPU usage keeps just going up. Thanks and sorry again. John

Hi Guys, I use my IBM ThinkPad (1.8GHz Intel Pentium 4, 1.0GB RAM running MS XP SP2) to monitor constantly changing parameters using Excel, which runs a macro every 2 minutes to update. The monitoring lasts for several hours per day. My question is that when I start running the machine (1st...

That looks more like it ... Thanks Zameer. My stop-gap solution was to put in a hyperlink in my worksheet to a .wav file on the drive and when a level was reached to activate the hyperlink. Not very elegant!! All the best my friend AJ