Hi

Using VBA, is it possible to retain an updated field within the VBA rather than in the workbook so a user cannot see the content of that field?

For example, I want to run a macro on specific dates in the month, so on opening the worksheet the macro will test @now againgst the content of that date field. If the date field = @now then I want to add five days to the date field, so the macro will run again in five days.

I don't want that date field to be held in the worksheet, or even in another protected worksheet, so is it possible to hold the updated date in VBA?

Thanks