View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JustBreathe JustBreathe is offline
external usenet poster
 
Posts: 22
Default Twist to eliminating the "Do you want to save..." prompt

Hi all,

I have various workbooks, which are prepared and utilized by co-workers,
that are hyperlinked into my workbook. I would like to be able to open and
refer to these hyperlinked files while giving a presentation of the data in
my own excel file, but then not be prompted with the "Do you want to save the
changes..." (even though I have made none) each time I click "x" to close
and return to my own file's window.

Is there programming that I can add to my own Excel file (or computer) to
eliminate this save prompt? I want to avoid making modifications in each and
every co-workers files, for fear that doing so could potentially disrupt,
cause lose of data or confusion in the way my various co-workers go about
saving, closing or exiting their files. Again I am accessing these files
through hyperlinks during my presentation , not a macro.

TIA!!!
Tanya