Forum: Visual Basic 4 / 5 / 6  Apr 21st, 2006 |
| Replies: 1 Views: 1,624 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... |
| Forum: Visual Basic 4 / 5 / 6 Nov 21st, 2005 |
| Replies: 5 Views: 2,602 just found this, its quite neat...
http://www.cpearson.com/excel/latlong.htm |
| Forum: Visual Basic 4 / 5 / 6 Nov 20th, 2005 |
| Replies: 5 Views: 2,602 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 29th, 2005 |
| Replies: 5 Views: 7,034 how do you go about setting up one of these userforms? Thanks so much for this help |
| Forum: Visual Basic 4 / 5 / 6 Oct 29th, 2005 |
| Replies: 3 Views: 3,787 sorry, didnt read the whole thing!
cheers man |
| Forum: Visual Basic 4 / 5 / 6 Oct 29th, 2005 |
| Replies: 3 Views: 3,787 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? |
| Forum: Visual Basic 4 / 5 / 6 Oct 29th, 2005 |
| Replies: 3 Views: 3,787 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 28th, 2005 |
| Replies: 5 Views: 7,034 no so that it's just my program that's in view...not the cell letters and numbers and tool bars and stuff... |
| Forum: Visual Basic 4 / 5 / 6 Oct 27th, 2005 |
| Replies: 1 Views: 1,902 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 20th, 2005 |
| Replies: 5 Views: 7,034 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! |
| Forum: Visual Basic 4 / 5 / 6 Oct 5th, 2005 |
| Replies: 4 Views: 5,716 Thankyou very much for quenching my thirst for knowledge! |
| Forum: Visual Basic 4 / 5 / 6 Oct 5th, 2005 |
| Replies: 4 Views: 5,716 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... |
| Forum: Visual Basic 4 / 5 / 6 Oct 3rd, 2005 |
| Replies: 4 Views: 5,716 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... |
| Forum: Visual Basic 4 / 5 / 6 Sep 29th, 2005 |
| Replies: 11 Views: 2,457 Yeah that's true, but I got the idea... |
| Forum: Visual Basic 4 / 5 / 6 Sep 29th, 2005 |
| Replies: 11 Views: 2,457 cheers, that's very helpful...
have a good one |
| Forum: Visual Basic 4 / 5 / 6 Sep 28th, 2005 |
| Replies: 11 Views: 2,457 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... |
