How Many Times Have The Book Been Opened Online Excel and Excel Macro (VBA) Courses Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Sub auto_open() Worksheets("Sheet2").Range("A1") = Worksheets("Sheet2").Range("A1") + 1 End Sub Report problem with this macro This macro does not work. There's an error in the code. Other You can write your comments about the error in the box below. Report error ALL MACROS Youtube Channel The following macros may be useful for you. Similar Results NoMacro Name 1 how many times have the book been opened 2 how many times has the file been opened 3 book total how many times which date and time opened 4 remove sheet / page protections 5 excel operators hk 6 type the date of the file and calculate how many days have passed 7 specifies in detail how many references the book contains (on new sheet / page) 8 specifies in detail how many formulas are in the book (on new sheet / page) 9 specify partition, list how many files you have 10 lists the named cells in detail on the wb_names sheet / page 11 specify the number of copies to print from the printer 12 Highlighted Named Ranges: If you are not sure how many named ranges are in your worksheet, you can use this code to highlight them all. 13 who opened the file 14 Who opened the file 2 15 txt who opened the file on what date 16 excel fonts 2 17 Data between cells a1: af12 flashes 18 Data between cells a1: af12 flashes 19 Show All Hidden Worksheets: Also if you want to hide all worksheets where you have hidden the previous code, your code is below. 20 magnifies the screen of the opened book