Hi,
I have the following code, which works fine to prevent people saving my file when I'm using excel 2007 (at work), however when I use it on my home computer, on excel 2013, the message pops up but I can still save the file, can anyone tell me why and how to fix it:
"Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox ("The 'Save As' function has been disabled")
Cancel = True
End Sub"
Thanks
Tom
Hi Tcowap,
This might do what you want, but you've got to disable events to get the code in and re-enable events to make it work
Option Explicit
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks a lot for this
Do you have any idea why my code stopped working when it moved from excel 2007 to excel 2013?
You're welcome! I have no idea, I'm on Excel 2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks