Search results

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...

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...

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...