Replies

Worked like a charm! Thanks Very Much Deb!

Any idea’s on the code for an event handler? I really ain’t got a clue where to even start on this one! I did think of using the KeyDown/KeyPress Handlers but my main problem is getting the program to give control to the user, otherwise the KeyDown/KeyPress Event handlers don’t Run and that’s as far as i got! Another thing i thought about was clearing the keyboard buffer and then checking if anything had been entered in it and stoping the program if it had, i know this can be donw with other programing languages but i aint sure if it can be done in VBA nevermind how to do it! So on summing up – PLEASE HELP!

Come on guys, it seems to be a rather simple problem??? PLEASE Help

Yes my system can boot from a CD-ROM and the Start floppy that i have loads drivers for my cd-rom. I made a boot CD and it works fine, thanks to all!

Jamie

Cheers, thats what i wanted to know! But i can’t see why it would be illegal, i’m only ‘Backing Up’ my CD, it’s not like i’m going to make thousands of copies and sell them, i just want to be able to boot from my CD-ROM instead of a floppy.

Thanks
Jamie

I think you guys mis-understood me, my fault, i wasn’t clear. I only want to do it for when i format my HDD and want to re-install windows, i don’t want to boot from a CD-ROM EVERYTIME, just when i want to format my HDD and re-install windows!

Cheers Guys, It worked a treat, saves me lots of time, and you’ll be glad to know i have decided to buy a rather large book on VBA, any ideas on which one is the best???

Jamie

Thats great, but how did you do it? If it takes too long to explain a rough idea would help, the thing is this file is a week old now and there is a up-to-date one at work that i need to apply whatever you done to the work sheet to.
Thanks
Jamie

I have attached the file i need the above to happen on. I can’t explaint it very well. I want the cell with the date in to change colour according to the day that date lands on! Please help. I’ve tried the code you told me and it says compiled error. Since i have NO experiance using VBA i don’t know what is wrong. thanks for trying to help but could you PLEASE try again?

thanks
Jamie

Sorry, I’m new to this!
If there is a date in say cell A1, i would have the =WEEKDAY(A1,2) formula in cell B1 to tell me what day the date lands on, i then want to put another formula into cell C1 to change the colour of cell A1 depending on the day in Cell B1. I could do it with conditional formatting if they gave me 5 arguments (i need a different colour for each day of the working week) but as usual MS have come up short. Hope anyone can help, cheers Jamie.

I could do it with conditional formatting but it only allows for three different formats to be applied, i need at least 5, thats why i want to do it by using the IF formula because i could nest up to 7 of them!

Jamie