2007 Compatibility pack - Context Menu

[AndyE45]

We still run Office XP on our Citrix servers and have installed the 2007 compatibility pack too. The problem we're having is the "Save As" Explorer context menu option. Some of the users are using this on Excel files and it messes them up because they don't understand what's happening when they up-convert.

How do I get rid of this context menu item? I've gone through lots of articles on how to modify you context menu in the registry but the entries for this aren't where I'd expect them to be.

Does anybody know how to do this?

 

[traycee]

How does this mess them up? I'm curious.

It shouldn't matter whether they save the file as a .xls or .xlsx. Installing the compatability pack just insures they can open files with Office 2007 extensions or if they choose they can save files with Office 2007 or not as they choose. No harm done.

 

[AndyE45]

Users are right-clicking on Excel XP files, choosing Save As and there are only 2007 options. The particular files have lots of macros and code in them that don't work in 2007.

We just want to get rid of the Save As option all together.

 

[traycee]

Thanks. I was curious. Odd users. Right clicking on the folder to save as opposed to simply opening the file, working on it, then closing it.

Tried it on an Excel file on a Citrix server and saw exactly what you mean.

Try this with one of your files in question. Create a macro that activates whenever someone right clicks:

Sub Disable_Shortcut()
CommandBars(21).Enabled = False
End Sub

This macro should do what you need.

The alternative would be to edit the registry in each computer....not a good alternative. Or train the users....maybe not real effective, either.

 

[AndyE45]

Traycee,

Thanks for the input. Could you please elaborate on where/how to set up the macro you mentioned? I could understand it being a startup macro for an Excel file but I don't know how to set it to execute when you right-click a file in Explorer.

I've been search for hours/days for how to disable it in the registry without success. It's not in the usual places that are mentioned by most articles. Doing this on each computer is not such a huge chore since this is all done on the citrix servers (no workstations).

I've now resorted to running regmon while I install the compatibility pack on a test machine to see where it writes stuff in the reg. It generated over 21000 events so sifting through this hasn't been fun and it still isn't clear where it creates the entry. That's why I was hoping somebody might know exactly what to change.

Thanks again.

 

[AndyE45]

I finally found a way to do it:

HKLM\Software\Microsoft\Office\12.0\MOC

There's an entry called "04" that handles the Save As command, I renamed it and now we still see the Save As option on the menu but when you click it nothing happens.

Thanks for the input just the same.