View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Mullane Mike Mullane is offline
external usenet poster
 
Posts: 1
Default Programmatically disable new smart options

I have an excel application with vba macros that is distributed via Citrix. I
have been able to disable many of the unwanted features of excel 2000 but we
are now upgrading to 2003. I need to disable a couple of the new features of
excel. Namely error checking and the paste and insert options. I know that
this can be done from Tools, Options etc. but that is on a per user basis.
And we don't even present the options menu and is more then we want to ask
the user to do.

I looked into Group Policy Editor but turning these specific features off
does not seem to be available.

Is there a way I can do it on start up of excel via VBA or for that matter
anyway to do it other than through mousing the menu options.

Thanks in advance.

Mike