hi,

how do make the label/caption of a form button on a sheet the same as the file name when you open the workbook
but only copy part of a file name of the workbook (the name to the left of the period ".")

example:
workbook file name is "4-APRIL.XXXXX"
when you open the workbook
the label/caption of the form button on the sheet will be "4-APRIL"