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.
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 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
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...
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...
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.
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...
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...
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,""))