M
mike
I have a macro that imports a txt file into Excel (it's a log file
another macro appends to) for the user to view upon clicking the "View
Log" button I made.
Problem is I need to remove the Save dialog box that comes up if the
user accidentally makes a change to the workbook. In the past users
have made changes to the log, went to close then clicked on Yes and
when that happens, formatting is lost and the log file goofed up.
I've tried workbook.saved = true, enableevents = false, displayalerts =
false and none work on this workbook that's created from importing the
text file.
another macro appends to) for the user to view upon clicking the "View
Log" button I made.
Problem is I need to remove the Save dialog box that comes up if the
user accidentally makes a change to the workbook. In the past users
have made changes to the log, went to close then clicked on Yes and
when that happens, formatting is lost and the log file goofed up.
I've tried workbook.saved = true, enableevents = false, displayalerts =
false and none work on this workbook that's created from importing the
text file.