View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Macros in Excel2007

Hi Arvi

As far as i know a deliberate decision

No way I will write applications in it,
without protecting all formulas from accidental delete,


You can protect your worksheets and your VBA without this problem.
But not use a File Open password or use the normal workbook protection.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Arvi Laanemets" wrote in message ...
Thanks Ron!

But when every user who has to work with files where sheets are protected
must edit registry ... !!!!! With which part of body they thought in MS when
they programmed it in such a way? Practically it means, that Excel will be
reduced to simple calculator. No way I will write applications in it,
without protecting all formulas from accidental delete, etc. And when the
user isn't allowed to change registry, even when he/she is capable of it?
P.e. in our firm users can't do this at all! And some applications are sent
to customers or suppliers - often abroad!

Do you have some information, is this a bug or deliberate decision? (When
bug, then there is some hope they'll fix it, otherwise I have to look for
some other program to write such applications - it looks like Office2000
will be replaced with Office2007 in our firm soon)


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Ron de Bruin" wrote in message
...
See
http://www.rondebruin.nl/password2007.htm