Well it sure works, not that I totally understand why, only snag is I and users double click on any workbook sheet and it put the time in, which is not so good, I know the name of the workbook.sheet.csv that I need this to work on and would really like it to only work for that workbook_name. sheet1Name, as there heaps of other macros in their personal.xlsb, so obviously this user can't use those other ones ,like all the other users at the moment (with 1X keyboard shortcut for all of the different exported.csvs presently all users just need to only remember the keyboard short cut key to auto run the appropriate macro for each *.csv based on the name of the exported file they have open. such as :
can this code you gave be amended to only work on a named worksheet like the other macrosSub DiscoverWhatRptRan() ' ' Keyboard Shortcut: Ctrl+g ' 'To Automatically choose the correct 'VBA based on sheet name 'using option/Case Statement Dim TheWorksheetname As String TheWorksheetname = ActiveSheet.Name If TheWorksheetname = "Exported Account1234 - " Then 'do something '//////////////////////////////////////////////////////////////////////////////////////////////////////////////////// Call macro1 Else MsgBox "File does not exist" End If If TheWorksheetname = "Exported Account4321 - " Then Call macro2 Else etc etc!
Reply With Quote