software

Hi

I have a read-only excel spreadsheet which my users open, there is a link to
an access database using ms query which automatically updates to show them
the latest information which they are supposed to use.

However, the little monsters, have a habit of saving it elsewhere and using
the wrong version. Is there any way i can stop them from saving it elsewhere,
i have tried removing the toolbars but i still get the 'File, Edit' etc menus
and anyway this isn't good because then they don't re-open when my users open
a completely unrelated spreadsheet.

Any help would be greatly appreciated.
Thanks
Emma

Emma,

Use the BeforeSave event. In the ThisWorkbook code module, paste
the following code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel
As Boolean)
Cancel = SaveAsUI
End Sub

This will allow the workbook to be saved, but not under a
different name.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Emma Hopequot; gt; wrote in message
...
gt; Hi
gt;
gt; I have a read-only excel spreadsheet which my users open, there
gt; is a link to
gt; an access database using ms query which automatically updates
gt; to show them
gt; the latest information which they are supposed to use.
gt;
gt; However, the little monsters, have a habit of saving it
gt; elsewhere and using
gt; the wrong version. Is there any way i can stop them from saving
gt; it elsewhere,
gt; i have tried removing the toolbars but i still get the 'File,
gt; Edit' etc menus
gt; and anyway this isn't good because then they don't re-open when
gt; my users open
gt; a completely unrelated spreadsheet.
gt;
gt; Any help would be greatly appreciated.
gt; Thanks
gt; Emma
Just to add to Chip's response...

This won't stop the little devils from using windows explorer and copying your
file and pasting to a new location.
Emma Hope wrote:
gt;
gt; Hi
gt;
gt; I have a read-only excel spreadsheet which my users open, there is a link to
gt; an access database using ms query which automatically updates to show them
gt; the latest information which they are supposed to use.
gt;
gt; However, the little monsters, have a habit of saving it elsewhere and using
gt; the wrong version. Is there any way i can stop them from saving it elsewhere,
gt; i have tried removing the toolbars but i still get the 'File, Edit' etc menus
gt; and anyway this isn't good because then they don't re-open when my users open
gt; a completely unrelated spreadsheet.
gt;
gt; Any help would be greatly appreciated.
gt; Thanks
gt; Emma

--

Dave Peterson

Chip. Excellent. thanks. Effectively it disables the save as and as i have
it read only that should do the trick!

Dave. I'm going to save the template somewhere obscure and I'm hoping my
little devils aren't that bright but thanks very much for the warning,
hopefully it'll put off all but the brightest of the bunch and i'll probably
be able to control them by bashing their heads together if they do!quot;Chip Pearsonquot; wrote:

gt; Emma,
gt;
gt; Use the BeforeSave event. In the ThisWorkbook code module, paste
gt; the following code:
gt;
gt; Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel
gt; As Boolean)
gt; Cancel = SaveAsUI
gt; End Sub
gt;
gt; This will allow the workbook to be saved, but not under a
gt; different name.
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;Emma Hopequot; gt; wrote in message
gt; ...
gt; gt; Hi
gt; gt;
gt; gt; I have a read-only excel spreadsheet which my users open, there
gt; gt; is a link to
gt; gt; an access database using ms query which automatically updates
gt; gt; to show them
gt; gt; the latest information which they are supposed to use.
gt; gt;
gt; gt; However, the little monsters, have a habit of saving it
gt; gt; elsewhere and using
gt; gt; the wrong version. Is there any way i can stop them from saving
gt; gt; it elsewhere,
gt; gt; i have tried removing the toolbars but i still get the 'File,
gt; gt; Edit' etc menus
gt; gt; and anyway this isn't good because then they don't re-open when
gt; gt; my users open
gt; gt; a completely unrelated spreadsheet.
gt; gt;
gt; gt; Any help would be greatly appreciated.
gt; gt; Thanks
gt; gt; Emma
gt;
gt;
gt;