Need Help To Disable Save As

Just a meeting place for professional offers & requests
Forum rules
Disclaimer: this section of the forum is just a meeting place for professional offers & requests. We do not and cannot insure the liability of the proposal made publicly in the forum or privately after contact has been made in the forum. Therefore, please take up the offers made here at your own risk.

Need Help To Disable Save As

Postby mindyRosenblatt » Sat Nov 21, 2009 6:38 am

I have built a Calc spreadsheet that I want to sell. If I password protect it customized to each customer, I find that someone can easily do a SAVE AS, and save it again without password protection, which means they could pass it around for free. I've found links on the web about the possibility of disabling Save As in Excel, but I don't know Macro programming, and don't know how to do this conversion. Or whether this is possible in Calc or not. Or if there is a better way to limit distribution of a program I have worked hard to create.

I am using OpenOffice 3.1, and running it on Windows XP.

Thanks so much to anyone willing to help!

Mindy R
OpenOffice 3.1 on Windows XP / OpenOffice 3.1 on MacOS 10.5
mindyRosenblatt
 
Posts: 2
Joined: Sat Nov 21, 2009 6:30 am

Re: Need Help To Disable Save As

Postby Hagar Delest » Sat Nov 21, 2009 9:00 am

Hi and welcome to the forum!

Does it help: [Solved] Can't figure out how to disable File > Open?

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Need Help To Disable Save As

Postby mindyRosenblatt » Sat Nov 21, 2009 9:33 am

Thanks for your reply. Sorry to be slow, but this level of programming is not my specialty. Are you suggesting that the same technique for disabling the Open menu can also be used to disable the Save As menu?

It looks like the link you mention was about an XML file. Is it a separate file that resides in the OpenOffice folder itself? How could I have my end users have this command automatically activated by simply downloading my Calc spreadsheet? That's what I need. I can't get them to install a separate file in the program itself I don't think...

Thanks for your patience to connect a few more dots together for me.

- Mindy
OpenOffice 3.1 on Windows XP / OpenOffice 3.1 on MacOS 10.5
mindyRosenblatt
 
Posts: 2
Joined: Sat Nov 21, 2009 6:30 am

Re: Need Help To Disable Save As

Postby Hagar Delest » Sat Nov 21, 2009 12:55 pm

Hmm, you're right, I mixed that configuration file with a macro. Sorry.
AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Need Help To Disable Save As

Postby eremmel » Wed Nov 25, 2009 8:07 pm

This discussion might help you further how i can manipulate openoffice writer document event: close/save.... You need macro programming and catch "SaveAs" if that is the right name. But when someone is willing to ship your document to others without pw protection despite the agreement/contract you have made, the step to share it including pw is not so large it is all about ethics. This is difficult up to impossible to manage.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8 for work with ORB; AOO4.1.4,LO5.2.5/6.0.5 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 1037
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: Need Help To Disable Save As

Postby mriosv » Sun Dec 13, 2009 3:11 am

Could be usefull for you, use the Tools/Protect/Document or sheets.
See in the OOo help [F1], searching for "protected contents".
There you can see the diferent protection levels.
LibreOffice 3.5.4 AOo-3.4 on Win 7 Ultimate
mriosv
Volunteer
 
Posts: 651
Joined: Mon Mar 09, 2009 1:12 am
Location: Galiza (España)

Re: Need Help To Disable Save As

Postby RichPorter » Thu Dec 04, 2014 3:35 pm

If you are looking to entirely remove the Save function VBA is probably your best option, just select Alt + F11, double click "ThisWorkbook" and paste the following into the module sheet:

Code: Select all   Expand viewCollapse view

Private Sub Workbook_BeforeSaveAs(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Cancel = True

End Sub



Sorry if I've misunderstood what you're after but this seems by far the easiest way around your problem (however I don't think this prevents saving in design mode).
OpenOffice 3.1 on Windows 7
RichPorter
 
Posts: 1
Joined: Thu Dec 04, 2014 3:24 pm


Return to Paid support

Who is online

Users browsing this forum: No registered users and 0 guests