Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I "lock-down" Excel, Word and Outlook from User Changes

Posted on 2004-04-27
5
Medium Priority
?
471 Views
Last Modified: 2012-08-14
I am building an application that will be accessible from inside and outside the firm.  Apps will be running under Terminal Services.  I want to lock down the three apps so users cannot make changes.  They will have to stay in their own directories and not see any other directories, AND not be able to change settings within the app to provide themselves access to other information.

Thanks...

0
Comment
Question by:rayva
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

by:Steiner
ID: 10935743
I guess this can't be done. I've seen lots of people spending months on that problem, trying so "secure" those apps, but there are still enough way around that "security", so I think it's not worth the time.

But if you still want to give it a try, a good point to start from is the command replacement using VBA (it works at least in Office97). There you have the possibility to replace the integrated commands (like FileOpen) with your own code.
To do that, go to the VBA-Editor, create a new module and insert a sub like that:

Sub DateiÖffnen ()
msgbox "Won't work!"
End Sub

Replace DateiÖffnen with the menu and command name of your Word Version (eg. FileOpen). Now Word should execute your code when the user clicks on File open (even works with Shortcuts). Now you'll have to go through each "dangerous" command and replace it with tha functionality you want it to have.
0
 

Author Comment

by:rayva
ID: 10939571
Steiner,

Thanks for your reponse even though it wasn't the news I wanted to hear.  

Given that I just want to keep each user in his or her own directory and hide all other directories from view, do you still feel this is not worth the time that it will take?

R
0
 
LVL 11

Accepted Solution

by:
Steiner earned 1000 total points
ID: 10946125
It depends on your goals and your users I think. If you just want to GUIDE the users so they don't use the wrong directory I think it should be just enough to replace the FileOpen and FileSaveAs commands by your own dialog. Therefore you should create a userform (eventually even an InputBox should be enough) where the user can enter a filename. Your programm then just adds a given path (next problem: where to get that from??) and saves the file right away.

But if you want to PROHIBIT access to other directorys, you'll have to think about many other problems: Disabling the VBA-Editor (that's complicated enough because there are many way to activate it), disabling all file-boxes where the user can enter a path directly, cutting down the windows explorer (because the user could just create a .doc using the explorer, double click on it, edit it and save it right away, remember that the Explorer can be started by the context menu of most file-dialogs). Then of course you have to assure that the user has no possibility to start Word without your modifications and a lot more to think of...

I think it would be far easier (and more secure!!) to use system permissions (NTFS, user privileges etc) to cut down access to the directories rather than trying to hide them using Word / Excel.
0
 

Author Comment

by:rayva
ID: 11008427
Sorry for the delay in responding.

Points are yours.

After doing some "menu cruisin'" I have to agree with you.  It would be next to impossible to block all the avenues of escape from a lock down.  

NTFS permissions is the route I'll try.

Thanks,
0
 
LVL 11

Expert Comment

by:Steiner
ID: 11012142
Sorry I could not give a better answer... but thanks for points and grade anyway!

I've seen people here trying to lock down Office for quite a while now. After they started it became kind of a sport for the users to go around all measures our people could come up with. So far it stands about 15:0 for the users ;-((. One problem is, if you lock down too many features you could use Notepad as well...
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question