Replies

Hans

Thank you very much, really very informative.
Once again your knowledge and patience has helped me a lot

Thank you once again

Hans

Thank you very much, I have one more question: what is the purpose of 9E+307 / -9E+307.
Sorry for the ignorant question but I always try to understand why something is done.
Thank you again.

Hans

Thank you very much for the help, it is much appreciated.

Regards

Hans

Thank you, that solved the problem.

One more question:

What code can I add for a message box to open for input of a new folder name?
This new folder must then be created automatically and the new workbooks stored in this new folder.

I have gone through a lot of the previous posts but can not seem to find something.

Groetnis

Hans

Thank you very much for the info, will action as suggested.

Regards

Kobus

Hans

Thank you very much, works perfect.

This will definitely save me many hours of work.

Regards

Hans

Thank you very much. I copied the code into a module but the macro do not want to run. I attached the revised workbook. Can you please be so kind as to advice what I did wrong.

Regards

Hans

Thank you for the lesson, this will help me a lot in the future. Now I understand why some things that I tried in the past did not work.

Thank you again

Regards

Hans

Thank you, it works great. May I ask another question out of ignorance?

I first pasted the code in a Module, which did not work.

I then clicked on the the Sheet name on the VB sheet and pasted the code in the space opened on the right hand side. Is the the sheet module as mentioned by you? What is the difference between this and the modules that appear as a seperate list after the work sheet names?

Greatfull if you can enlighten me?

My dank aan jou, in my opinie een van die groot Excel meesters.

Regards

Hans

Your remark on unable to choose anything from the drop down box promps another question.

Why does this happen, every body in my office who use the protected versions from any of my sheets are able to choose options from the drop down boxes.

Are different versions from Excel not compatible? Or some other reason?

Regards

Sorry Hans

I attached an open version.

Regards

Steve

Thank you for the reply

I attach a workbook to explain. In the workbook there are a few sheets with a “2” in the sheet name. On the General Info sheet is a drop down box with the name Order Value. If you choose the first choice all the sheets with a “2” in the name must be hidden. Any other choice should show all the sheets.

Hope this helps.

Regards

Rory & Dean

Thank you for your great work, this will save me hours and hours if not days of work per month. I do not know how I will solve all the problems without this Forum’s help.

I realy appreciate it.

Thank you again

Hans

Baie, baie dankie vir jou wonderlike werk.

This is 100% what I needed, thank you very much.

I am very sure that I speak for all who enjoy and benefit from the input of yourself, Steve, Rory, etc, etc, who put a lot of your time in to help us, when I say I can not emagine operating without this Forum.

Thank you again

At this moment there are 32, but it is not always the same. 50 should be the maximum.

You are correct, it will be done at least once a month with a maximum of about 3 times per month.
Thank you