Hi,

I am creating a spreadsheet to manage my personal accounts. As part of my calculations I have included my annual tax allowance. Bearing in mind that the tax allowance changes year on year I would like to provide myself with a reminder on the 01st April each year.

Please would someone be able to provide me with some VBA code to enable this.

The cell which represents my tax allowance is B7.

In addition......

Would someone be able to provide some VBA code in order to lock a single cell/range of cells? I have been able to do this so far by utilising the Tools>Protection>Protect Sheet function and only enabling the cells I would like locked within Format Cells>Protection>Locked. However, in locking those cells I lose the ability to do various things within Tools, Format, Data, Insert.

Any assistance on both questions would be greatly appreciated.