------------------- "Excel Diary" -------------------

"Excel Diary"with text search, photo insertion, emoticon insertion, and scheduling functions. There is a sense of security in such a natural function of Excel that the written text remains on the sheet. Click here to download
https://excelkobo.net/download/ExcelDiary.zip　
In order to use "Excel Diary", you need to "Enable" the macro setting of your Excel. Let's do that first.
To enable macros in Excel, you can change your macro settings in the Trust Center: 
(1)Click the File tab 
(2)Click Options 
(3)Click Trust Center, and then click Trust Center Settings 
(4)In the Trust Center, click Macro Settings 
(5)Select Enable all macros 
(6)Click OK to save your changes 
The macro setting is now "Enable". You can verify that macros are enabled by: 
(1)Closing Excel and opening it again 
(2)Going to the Developer tab in the ribbon 
(3)Clicking the Macros button 
(4)Checking if you can see the Record Macro option 

----------------- How to use "Excel diary" -------------------

1.The password is "99999999".

　If you want to set your own favorite password, please open with this password and set it again.

2. Explanation of each button

Sheet "Diary"
[Diary Entry] ? Displays the diary entry form.
[Print] ? Displays the print form.
[Master] ? Displays the date master sheet.
[Open] ? Directly displays the diary entry form for the date currently cursored on the sheet.
[List] ? Displays a list of appointments for today and later in the form.
[Photo Diary] ? Displays the "Diary" sheet.
[Emoticons] ? Displays the "Faces" sheet.
[Search] ? Displays a search form.
[Memorandum] ? Displays the memorandum form.
[Email] ? Transfers diary entries to Outlook for display.

Sheet "Date Master"
[Diary] ? hides the "Date Master" sheet and displays the "Diary" sheet.
[Delete] Entry Rows ? Displays a form for deleting data that has already been entered.
[Add Entry Row] ? Displays the Add Entry Row dialog box.
[Sort] ? Displays a form for sorting the holiday list.
[Change Holiday] ? Displays the Change Holiday form.

This section describes how to fill out the "Memorandum Form Link and Button Settings" form. First, decide on a name for the button and enter it in the "Title" column. Next, in the "Link Address" column, enter the full path of the URL address or the name of the file on your computer that you want to open. To enter the full path, follow the instructions below.
(1) Right-click on the icon of the file you want to open and click Properties (R).
(2) Copy the path shown in "Location:".
(3)Paste it into the "Linked Address" column of the "Button Settings for Memorandum Forms".
(4)Copy and paste the file name (do not forget the file extension) followed by the "\" mark and then the file name.
(5) Overwrite the file and save it.
After the above, go back to the "Diary" sheet and open the "Memorandum" form. You should see a link button at the top. If not, close the file and reopen it.

Sheet "Photo diary"　
[Diary] ? Hides the "Photo" sheet and shows the "Diary" sheet.
[Date] ? The cursor will jump to the cell with the specified date.　　　　　　　　　　　　　　　　　　　　　　　
[Insert Photo] ? Displays the Insert Photo dialog box.
[Print] ? Displays the print form.
[Insert Memo] ? Displays a form for inserting a memo in the selected cell.
[Unprotect] ? Displays a form to unprotect or protect the sheet. Unprotect- Toggles between unprotecting and protecting the sheet.

Sheet "Faces"
[Diary] ? Hides the "Faces" sheet and displays the "Diary" sheet.　

You can add up to 65,536 input lines by 365 lines by clicking the "Add Input Lines" button on the "Date Master" sheet. You can also delete unnecessary lines before you start writing by clicking the "Delete Input Lines" button.
You must live to be over a hundred years old to finish writing in all the lines of the "Excel Diary" diary sheet (lol).
In ver. 4.14, you can customize the regular closing days. That’s all. Thank you.

https://www.youtube.com/watch?v=3yBcqi9thpI
