View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 24
Default Block save file prompt in imported txt file?

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.