Search results

A Happy Yuletide to all!

asa, You're right about the datedif equivalence don't know what I was thinking. Still, it seemed to work. kmakifl, Hope you can adapt it to your needs. asa will keep you right.

Have corrected the above file! ^^^ Auto

Thanks asa, that seems to have solved the problem. I appreciate the time and effort you've expended on my behalf. Shalom Auto

Hi! Did as instructed and get error as follows:- Runtime error '1004' Method 'showdataform' of object '_worksheet' Hope this means something to you, as it means nothing to me :)) Auto

Hi asa, Thanks for your reply. I'm pretty sure that this is what I'm after. but, how to implement it! I'm a real VBA novice, Do I just right click the sheet in question and click "View Code" then paste it in?

Belay that command Mr. pob. My mistake, it works just fine. (forgot to unprotect on first use) The second part of my original post was concerning the basic Data entry form not the "user form". Hope this is still making sense and thanks again for your help. Shalom

Hi pob, Unfortunately it doesn't work! The code unprotects the "Monthly Sorted" sheet as before but not the "Data" sheet. Any ideas?

Hi kmakifl Don't know if this is what you're looking for But, I've posted a file here: http://dl.dropbox.com/u/16092591/Datedif.xlsx Hope this helps. Shalom

Thanks for the speedy reply pob. I'll try it out and report back. Although, probably not till tomorrow. Shalom

Hi Folks, A few days ago Luke was kind enough to help me with a bit of code which worked a treat. It was to except a sheet from being protected. I need to add another sheet, called "Data" to the exception rule. I Tried to adapt the code Luke sent me but failed miserably :(( Here is the code...

Luke, you the MAN! Works a treat. Thanks. Auto

I've just thought. There is no need to protect the "Monthly Sorted" sheet. Does that make any difference? Auto

Hi Luke, Thanks for the reply. I've changed the macro but, no good. I still get an error pop-up saying "cannot edit pivot table on protected sheet" Another try? Auto

Hi Folks, Sorry for the long topic heading but... I'm trying to produce a timesheet/invoicing system and all is going well except for this one problem. I know NOTHING about vba and I have two small bits of code picked up off the web. 1. Some code to enable outlining in a protected sheet...

Thanks hui & xld that's got it sorted.

Nice idea xld but it just screws up the times. I need something that will give me a proper time which I can manipulate. (I need to do some calculations with the resulting times) Thanks anyway

Hi Folks, I've imported a file from the web and it has times formated thus "06.45" (without the quotes). How can I convert it to a proper time format e.g. 06:45 in order to work with them. Thanks.

Thanks Hui, It was the ABS function I had needed. Thanks again Auto

Hi Folks, I have a cell which shows zero which is what I require. But when I need the following cell to appear as null then excel says the value is non zero. On running the formula evaluator I find that the value is not zero but something like .0000000007. I should know how to correct this...

Thought someone might be interested in this. It's an Excel interpretation of the simple substitution cypher much beloved of children's authors. I've posted it here because it's not really a request for help. It's in XL 2010 although I suppose it works in 2007. Anyway here it is. Feel free to...

Hui "Give the following a burl:" I very near besmirched me britches. (Apologies for off topic.)

OK! This is going to be a bit of a rant. So bear with me. The amount of help myself and others get from this forum is astonishing. The friendly and altruistic attitude of contributors like Luke & Hui is humbling IMHO. So, what REALLY gets my goat , is the number of posts where solutions are...

Way to go Luke! I was wondering when the accolade was going to be awarded. well Done! And, richly deserved. shalom Auto

Here's an alternative I found on the Web some time ago. I can't remember where but it may have been Chip Pearson's site. =IF(A1=1,"Neither",IF(A1,OR(A1={1,2,3},AND(MOD(A1,ROW(INDIRECT("2:"&INT(A1^0.5))))))+0,""))