View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default VBA project unviewable in office 97

Hi Rob

If you protect your VBA code in Excel 2000-2002 you can't view it in Excel 97.
I always protect(VBA) my workbooks in Excel 97 before I distribute it


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Rob" wrote in message ...
I've developed my VBA project in office XP and want to distribute it to PCs with office 97. I realised that I'd have to play

about with bits of the code on an older machine before I could send it out, but thought I'd at least be able to view and edit
the code. If I open the project in Office 97 it tells me the project is unavaliable for viewing. I've looked in the Knoledge
base, and found this: http://support.microsoft.com/default...b;en-us;169374 but my workbook isn't shared.

Any suggestions??
Thanks in advance
Rob