Hi there everyone

Im pretty much a novice with macros and wanted some advice.

I need to run a macro once a week when the work sheet is opened
i want to be able to freeze a button, lock some cells and delete some other cells over a 13 week period but i only want this action carried out once a week once the user opens it the first time in that week. is this something that is easy enough to do and if you can please give me some rough coding..

i would then carry out another macro to repopulate the cells, unfreeze and unlock which is easy enough to make using the record function

Thanks for any help that can be given