View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_6_] Jon Peltier[_6_] is offline
external usenet poster
 
Posts: 17
Default Not allowing an Excel Worksheet to be opened in Word

How do the users open them in Word? Is there a broken file association?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

John wrote:

I have some workbooks that are shared by many users. For some reason, the workbooks are opened in Word. When this happens it plays havic with the shared properties of the workbooks. Is there a way to set these workbooks so they can't be opened by Word? I have tried adding code to the Workbook Open Event, but it is bypassed when opened in Word. Any suggestions?