Macro: For Having Current date entered cell in all sheets

Thanks for Looking. I was wanting to create a macro that would simply enter the current date into cell B2 on all sheets in the workbook. Thanks as always.

Please Login or Register  to view this content.

Someone else may have an easier way, but I have found that using the TODAY function on Sheet 1 in cell B2 will give you today's date. On the following sheet, you can input the following formula and it should change the date every day.

=Sheet1!B2

If you have 150 sheets, do you have to put in the formula in every sheet, or is there any other way round?

Thanks for the reply.. I forgot to mention that the macro will be in the hidden personal workbook. The workbook that it will be working in is password protected. Password- ABCD1234