Hello, I have a calc file which is basically an inventory record. Periodically, I record inventory amounts, then I want to save the sheet (create sheet copy), rename it with today’s date, and protect that sheet, keeping the current sheet unprotected.
I am trying to create a macro to do this also. Am unable to rename a sheet with today’s date, when I do I get “=today()” which is what I enter. Did this in excel many years ago, so can’t recall exact steps or functions. Is there a better function, how do I format, also how do I make it so it always saves todays just behind the “master” sheet.
Thank you for your help.