I have taken a workbook with numerous macros that I want to make available to several users & placed it on a shared network drive. Then I placed a shortcut to that workbook in each of the users excel/startup folder
and I then Shared the workbook.
All is good except that whenever one closes excel it wants to SAVE that workbook. How can I keep that from happening?
I want the file to just close without saving or offering that option.
Any Ideas?
and I then Shared the workbook.
All is good except that whenever one closes excel it wants to SAVE that workbook. How can I keep that from happening?
I want the file to just close without saving or offering that option.
Any Ideas?