I wish to password protect my worksheet. However, I have some Macros which have to unprotect the sheet in order to add a text box and then protect the sheet again. Is it possible to unprotect a...

just found this, its quite neat...
http://www.cpearson.com/excel/latlong.htm

Is it possible to format a cell so that an angle in degrees can be shown as an angle in degrees minutes and seconds? Any help would be much appreciated...

how do you go about setting up one of these userforms? Thanks so much for this help

sorry, didnt read the whole thing!
cheers man

How do you make this work though? Sorry I'm a bit thick! How would I put this into a function so that a cell would read the time?

I'd like excel to write the time when one of my macros tells it to copy and paste some cells into another workbook. I'd like it to paste the time into the other workbook. Any help would be much...

no so that it's just my program that's in view...not the cell letters and numbers and tool bars and stuff...

Can someone help please? Is there a way that I can make everything on the screen disappear except for my program when it loads?Any help would be much appreciated...

I've been trying to create a macro which closes excel without the save pop-up coming up, anyone got any ideas? I don't want it to save, this is because i don't want anyone who uses it to muck it up!

Thankyou very much for quenching my thirst for knowledge!

Thanks, i'll check if it works, how does it work?What's Atn?What's the theory behind it?Any help would be much appreciated, i'd like to understand you see...

I've looked in a couple of books, and can't find this anywhere, i'm looking for the opposite of the cos funtion, i.e. I know the cos of the angle, and need to know the actual size of the angle, is...

Yeah that's true, but I got the idea...

cheers, that's very helpful...
have a good one

HI, sorry if this is really thick, but I'm abit stuck...I have written this piece of code as part of a bigger function:

If Z = 1 Then
SIDE = W - (V / 3600#)
End If
If Z...