Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricted Save As option to all work stations
Hello,
I have a database of 180 workbooks with multiple sheets on sharing through network drive, soem user have read+write rights and some have read-only rights. I want to protect every workbook that no one, specially with the read only rights, can save the workbook on their desktop and Copy Paste the workbook as a file on their hard disk. Is there any suggestion, it would be relly helpfull |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricted Save As option to all work stations
Saving is the easy bit, use
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) msg = "I don't want you to do that" MsgBox (msg) If SaveAsUI = True Then Cancel = True End Sub For preventing cut, copy and paste etc look here. http://www.vbaexpress.com/kb/getarticle.php?kb_id=373 "Salman" wrote: Hello, I have a database of 180 workbooks with multiple sheets on sharing through network drive, soem user have read+write rights and some have read-only rights. I want to protect every workbook that no one, specially with the read only rights, can save the workbook on their desktop and Copy Paste the workbook as a file on their hard disk. Is there any suggestion, it would be relly helpfull |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restricted Save As option to all work stations
Thanks, I am trying these codes, while please advice;
By using these code would I, the owner of the worksheet, be able to open workbook with all administrative options or is there any option to use password or have to developed another macro to disbale these codes. Will I be able to get values from these protected worksheets in another worksheet through formula. and last do I have to paste the code in every worksheet, already developed, seperately?. Regards. "Mike" wrote: Saving is the easy bit, use Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) msg = "I don't want you to do that" MsgBox (msg) If SaveAsUI = True Then Cancel = True End Sub For preventing cut, copy and paste etc look here. http://www.vbaexpress.com/kb/getarticle.php?kb_id=373 "Salman" wrote: Hello, I have a database of 180 workbooks with multiple sheets on sharing through network drive, soem user have read+write rights and some have read-only rights. I want to protect every workbook that no one, specially with the read only rights, can save the workbook on their desktop and Copy Paste the workbook as a file on their hard disk. Is there any suggestion, it would be relly helpfull |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Everytime I save my workbook, my hyperlinks will no longer work. | Excel Discussion (Misc queries) | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
I cannot save work I have entered in Micosoft Excel 2000- | Excel Discussion (Misc queries) | |||
No Save As option | Excel Discussion (Misc queries) | |||
Disable "Save As" Option | Excel Discussion (Misc queries) |