Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I block users to save the excel file if conditions not met | Excel Discussion (Misc queries) | |||
Prompt to save file | Setting up and Configuration of Excel | |||
How to block file Save (^S)? | Excel Programming | |||
Prompt for Save when closing a file | Excel Discussion (Misc queries) | |||
Save file -prompt | Excel Programming |