[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 825
  • Last Modified:

Excel add in for few users only on Citrix Xenapp 6

Hi All,

I have a problem in that we have a requirement for an Excel add in that is quite sensitive and therefore I only want it available to a few users. With Citrix, it seems that if an add in is installed it is available for all users. Is there a way to restrict who gets access to what add-in?
0
MSSC_support
Asked:
MSSC_support
1 Solution
 
Zack BarresseCEOCommented:
Hi there,

Depends on how you want to set it up. Assuming you're talking about an XLAM add-in, you can utilize it's OnOpen method to check the computer name and username when opening. You'd either need to have a pre-populated list with the data on it for who can view it.

When I install an add-in I always put it in C:\Windows\Addins, so it is easily available for everyone. By default add-ins are installed to the current users path:

C:\Users\USERNAME\AppData\Roaming\Microsoft\AddIns

Wouldn't you just control who was able to download/install the add-in though? Seems like it would be easier to do that than try to code around it.

Regards,
Zack Barresse
0
 
Sekar ChinnakannuStaff EngineerCommented:
The Workaround for this requirement is publish the Excel with specific addin which user request and give permission only to specific users.
0
 
MSSC_supportAuthor Commented:
Well it is going to sit on a terminal server environment. It is a Sage plugin on Excel. I only want this add in visible to the few finance users.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Tony JLead Technical ArchitectCommented:
Ok, assuming you're using a published desktop:

The way I've done this, personally, in the past is to have two shortcuts for excel and a script that copies the relevant one based on group membership.

The one for users who do not need the plugin is simply to add /s after excel.exe in the shortcut - this starts it in safe mode which disables plugins.

If it is a published application it's even easier because you just have two published Excels and one is the safe mode version.

You may want to check with your version of Excel exactly what safe mode disables before you do this as it's been some time since I did it this way and for that company, their demands on Excel were absolutely minimal so it broke nothing.
0
 
MSSC_supportAuthor Commented:
We use excel 2010. We do not use add ins except for Sage so I will try that and get back to you.
0
 
MSSC_supportAuthor Commented:
I tried it with the /s switch and the add in still runs. And yes we use published desktop.
0
 
MSSC_supportAuthor Commented:
sekarc4u, how do i do that?
0
 
MSSC_supportAuthor Commented:
Also,

doing some more research it is a COM add in.
0
 
MSSC_supportAuthor Commented:
Anyone else have any ideas?
0
 
Zack BarresseCEOCommented:
If it's a COM add-in you either need access to the source code, or you have to manage the folder location in which it's located with permissions. Might be worth asking Citrix directly.

Zack
0
 
MSSC_supportAuthor Commented:
Worked like a charm! It fails to load the add in with the permissions and you cannot force it to work.
0
 
Martin LissRetired ProgrammerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now