My code crashes excel

Thanks but that isn't it

Thanks..I gave it a go and it worked fine but didn't add the code to worksheets. There is a second problem with with finding the codename of the sheets. The first time you run it, it will return a blank value. All othertimes it works fine.

I solved the first problem....Its was because I had the form open in the background and never closed it after then new sheet had been inserted. I tried a simple hide then show again (because i need the form to be open at all times) but that did't work either. What worked was hiding the form and then opening it using module that only had form.show in it and calling it using the ontime method 1 second after I close the form.

I know that it sounds crazy and i'm not sure the reasoning behind it working ut its works and im happy.

Thanks for all your help Bryan

Originally Posted by ben_sumner

Thanks..I gave it a go and it worked fine but didn't add the code to worksheets. There is a second problem with with finding the codename of the sheets. The first time you run it, it will return a blank value. All othertimes it works fine.

I solved the first problem....Its was because I had the form open in the background and never closed it after then new sheet had been inserted. I tried a simple hide then show again (because i need the form to be open at all times) but that did't work either. What worked was hiding the form and then opening it using module that only had form.show in it and calling it using the ontime method 1 second after I close the form.

I know that it sounds crazy and i'm not sure the reasoning behind it working ut its works and im happy.

Thanks for all your help Bryan

Good to see, as you observed, it was a little over my '10%'.

Thanks for the response.