View original (French)

Creating a logbook in Excel

Xander64 Posted messages 5 Status Membre -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   -
Hello everyone,

I’m reaching out to you on this forum because I’m in the process of creating a spreadsheet that would work in Excel. I have already managed to set up quite a few things, but I still have some gaps. First of all, I would like to lock certain cells to prevent their content from being deleted while keeping other cells unprotected so that we can still edit them.

I have a time column, and in that column, I would like the time to be entered automatically without us having to fill it in ourselves, and lastly, the saving of the sheet in a separate sheet but still within the same workbook. I hope I have managed to explain myself clearly to you.

Thank you in advance for your future replies, and have a great Sunday.

2 réponses

Réponse 1 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
Hello

Here is the beginning of a file, there are macros so it will be necessary to validate upon opening Excel

http://www.cjoint.com/c/ELhjNyleZEx

--
It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from one's mistakes.
1