It will find any new sheet you add. You just need to ensure you maintain the date format in the sheet tab name. And yes, you can call it from any sheet. Need to have a small modification in the code.
Remove
Code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Call CalendarCellButton
End Sub
from the index sheet module, and copy the following in the Workbook code module
Code:
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Call CalendarCellButton
End Sub
Bookmarks