I have the following in my "ThisWorkBook"
what im trying to do is create a work sheet called 'Report for AA17' (AA17 is in dd-MMM-yy format, but the tab should read 'Report for MMM dd, YYYY') when the workbook is opened, and if the sheet is already created and present dont create...Private Sub Workbook_Open() Worksheets("Blank").Activate Run "HideRibbon" End Sub
thoughts?
Thank you...