Replies

Hi Zeddy

It’s hrs:mins

Thanks for the reply
Braddy

Hi Rory

I think I have a problem elsewhere because I cannot get your code to work. I will have to do some checking.

Many Thanks for the code.

Regards
Braddy

Hi

I tried it in the sheetchange event but it runs every time the sheet changes whether I3 to I34 contains Duplicate Booking or not.

Regards

Braddy

Hi RetiredGeek

Thank you for the Code

Could I impose on you to explain exactly where to place this code, Many Thanks.

Regards

Braddy

Hi Rory

Thanks for that.

Regards

Braddy

Hi Rory

Thanks again, is there somewhere I can learn about entry forms?

Regards

Braddy

Hi Rory

Thanks for the reply, would it be any simpler if I removed Data Validation?

Regards

Braddy

Hi Rory

Everything seem to be working now, please accept my sincere thanks for all your help.

Regards

Braddy

Hi Rory

Sorry I refer you to my signature, Sorry to be a drag, but now I am getting the comparability checker warning, please say if I am being a nuisance.

Regards

Braddy

Hi Rory

I will try to explain, when I run the template,with the benefit of your code it runs perfectly and saves the file just as it should no problem, it is only when you open the saved file you get message about the extension, if you say yes to open that’s fine as well, it does not increment the saved file with name po_0000xx, In fact everything works it’s the niggle about file extension.

I have attached one of the saved files and the template.

Many thanks

Braddy

Hi Rory

Forgot to say I am using Excel 2010

Regards

Braddy

Hi Rory

It’s xlsm, there are no macros as such only VBA code

Regards

Braddy

Hi Rory

have changed code as suggested no joy, naive question is it referring the the difference between xls and xlsm?

Regards

Braddy

Hi Rory

Once again I am in your debt, that worked fine

I get this message when I re-open the saved po_ is it a problem or do I just have to live with it?
The file you are trying to open,po_000008.xls is in different format than specified by the file extension.Verify that the file is not corrupted and is from a trusted source before opening the file. do you want to open the file now?

It doesn’t increment the saved file, but may confuse the user

Hope the children didn’t keep you awake last night 🙂

Regards

Braddy

Hi Rory

I overlooked a problem when any body opens the saved order for instance po_00003 that increments as well which will obviously ruin the records.

Any ideas please.

Regards

Braddy