barefaced
01-11-2007, 01:59 PM
Hi, am posting to take advantage of the obvious expertise in this forum...ok grovelling over.
I am trying to create a To-Do list, which will automatically (or at the press of a button) cut and paste a range of data from the active worksheet to another named worksheet in the workbook, based on a date being entered in Column G of the active worksheet. I would like all but the one named ("Completed") worksheet to be protected so that I am only tabbing through certain columns.
I've got some code in the workbook module, which was working up to a point, but seems not to now. Any help would be gratefully received. I'd also like the macro to run either as soon as the date is entered in the column or by clicking a button on the toolbar. I've attached what I've done so far.
Cheers
I am trying to create a To-Do list, which will automatically (or at the press of a button) cut and paste a range of data from the active worksheet to another named worksheet in the workbook, based on a date being entered in Column G of the active worksheet. I would like all but the one named ("Completed") worksheet to be protected so that I am only tabbing through certain columns.
I've got some code in the workbook module, which was working up to a point, but seems not to now. Any help would be gratefully received. I'd also like the macro to run either as soon as the date is entered in the column or by clicking a button on the toolbar. I've attached what I've done so far.
Cheers