| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as
Hi, is there any way I can put a password on save as, I have a work book
other people use and some how they keep saving as by accident, it happens when they use F5 to go to a sheet, any ideas on the password or how they are managing to go to save as? Thank you in advance, Barry. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save as
The ususal culpret for that is selecting File - Save As , instead of File -
Save. You can add this code to the ThisWorkbook module... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = True Then If MsgBox("You selected Save As. Is that what you wanted to do?", _ vbYesNo + vbDefaultButton2) = vbNo Then Cancel = True End If End Sub -- HTH... Jim Thomlinson "wildauk" wrote: Hi, is there any way I can put a password on save as, I have a work book other people use and some how they keep saving as by accident, it happens when they use F5 to go to a sheet, any ideas on the password or how they are managing to go to save as? Thank you in advance, Barry. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save as
Sounds perfect, where can I find this work book module.
Barry. "Jim Thomlinson" wrote: The ususal culpret for that is selecting File - Save As , instead of File - Save. You can add this code to the ThisWorkbook module... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = True Then If MsgBox("You selected Save As. Is that what you wanted to do?", _ vbYesNo + vbDefaultButton2) = vbNo Then Cancel = True End If End Sub -- HTH... Jim Thomlinson "wildauk" wrote: Hi, is there any way I can put a password on save as, I have a work book other people use and some how they keep saving as by accident, it happens when they use F5 to go to a sheet, any ideas on the password or how they are managing to go to save as? Thank you in advance, Barry. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save as
The easiest way to get there is to right click the XL icon next to the word
Fle in the XL menu. Select View Code... paste the code from my previous post. -- HTH... Jim Thomlinson "wildauk" wrote: Sounds perfect, where can I find this work book module. Barry. "Jim Thomlinson" wrote: The ususal culpret for that is selecting File - Save As , instead of File - Save. You can add this code to the ThisWorkbook module... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = True Then If MsgBox("You selected Save As. Is that what you wanted to do?", _ vbYesNo + vbDefaultButton2) = vbNo Then Cancel = True End If End Sub -- HTH... Jim Thomlinson "wildauk" wrote: Hi, is there any way I can put a password on save as, I have a work book other people use and some how they keep saving as by accident, it happens when they use F5 to go to a sheet, any ideas on the password or how they are managing to go to save as? Thank you in advance, Barry. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save as
Hi Jim,
I tried it in a blank workbook and it works great. Thank you, Barry. "Jim Thomlinson" wrote: The easiest way to get there is to right click the XL icon next to the word Fle in the XL menu. Select View Code... paste the code from my previous post. -- HTH... Jim Thomlinson "wildauk" wrote: Sounds perfect, where can I find this work book module. Barry. "Jim Thomlinson" wrote: The ususal culpret for that is selecting File - Save As , instead of File - Save. You can add this code to the ThisWorkbook module... Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = True Then If MsgBox("You selected Save As. Is that what you wanted to do?", _ vbYesNo + vbDefaultButton2) = vbNo Then Cancel = True End If End Sub -- HTH... Jim Thomlinson "wildauk" wrote: Hi, is there any way I can put a password on save as, I have a work book other people use and some how they keep saving as by accident, it happens when they use F5 to go to a sheet, any ideas on the password or how they are managing to go to save as? Thank you in advance, Barry. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save, save as, page setup dimmed out in unprotected excel sheet? | Excel Discussion (Misc queries) | |||
| Disable save, save as, but allow save via command button | Excel Programming | |||
| How to diasble save and save as menu but allow a save button | Excel Programming | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
| Save As - Multiple Sheets fails to save as text file | Excel Programming | |||
Linear Mode
