menor59
03-11-2013, 11:07 AM
I have the following in my "ThisWorkBook"
Private Sub Workbook_Open()
Worksheets("Blank").Activate
Run "HideRibbon"
End Sub
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...
thoughts?
Thank you...
Private Sub Workbook_Open()
Worksheets("Blank").Activate
Run "HideRibbon"
End Sub
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...
thoughts?
Thank you...