Recent content by Trebby

Sorry chaps. This is for VBA.

Hi All, I have found a nice little code that allows me to insert a row when double clicking on a cell, copying contents as well. I was wondering if I could change it so it inserts a row if you click on the cell value '+' and deletes a row if you click on the value '-'? allowing me to insert and...

I've come across a solution using date pick, I'can't post link as I have made less that 10 posts.

Hi Ranman Thanks for replying. Our IT department has only recently updated our software from 2010 to 2013 (though a couple weeks back) and only stopped working today. As we are not the administrators of the units what would be the best suggestion for me to do? I've tried opening this sheet on...

Hi, Currently using Excel 2013 and upon opening my spreadsheet this morning I get the message "Could not load an object because it is not available on this machine". I then go to one of my userforms and notice the calendar has gone, and it's also not an option on my toolbox (not even on...

Tried it - and it worked but still getting the loading time, which I believe is due to loads of worksheets being protected and grouping. Again... Thanks for the time and help.

Thanks Namliam - I think the issue I have is it's such a big file, with loads of formulas. Dan has shorted the code for me which is better. I will run with this for now, until I find an alternative method. Thanks for your help guys.

Hi Dan, Thanks for taking the time to look at this. Love the compactness of this code but unfortunately it's still jumping from sheet to sheet when loading up. lol... yep. Still new to VBA, and I doubt there is code worth stealing or indeed information.

Hi, I'm wondering if you can advise? I have a bit of code that does everything I need (allows ungrouping when sheets are protected) but when the workbook is first loaded it runs a lot of checks (worksheet to worksheet) and loading time is slow. I am wondering if my code can be adjusted or...

Hi, Please can you advise? I'm still very much a novice to VBA coding and would like some help before I lose all my hair for good I'm trying to allow staff to enter text into merge cells, and once the deadline date has passed it will auto lock these cells so editing cannot be done (audit...