Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Twist to eliminating the "Do you want to save..." prompt
Hi, in my opinion, try using the hyperlinked files in read-only mode. I guess
that should solve your problem. "JustBreathe" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to disable "save" prompt in excel file on web server? | Excel Discussion (Misc queries) | |||
Disallow "SAVE" only "SAVE AS" or prompt | Setting up and Configuration of Excel | |||
Close without "Do you want to save changes" prompt | Excel Programming | |||
How to make the "Save As" prompt appear with vba? | Excel Programming | |||
How can I get "File Close" to prompt me to "Save Changes" ?? | Excel Programming |