No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
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... |
|
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 password protected sheet?And then password protect it again after the object has been … |
|
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! |
|
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'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 appreciated. |
|
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 there an implicit function? If not, how can I achieve … |
|
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 = 2 Then SIDE = W + (V / 3600#) End … |