Macros in Excel2007

[Arvi Laanemets]

Hi

So long I have used Excel2000. No I started with Excel2007, and immediately
encountered a cople of problems.


In Excel2000, I had Macro Security set to medium - whenever I (or user)
opened a file with a macro in it, I (or user) was asked to enable or disable
it.
Now in Excel2007, when I set Macro Security to 'Disable .. with
notification' (what must match with my previous setting?), the file is
opened without Office asking me anything, and whenever I want to run the
macro, I get the message that macros are disabled. So long the only
solution, I was able to find, was to set Macro Security to 'Enable all
macros', which does match with low security in old version!

Now, with all macros allowed, I wanted to assign a shortcut to macro. But
when I select the macro in Macro window, only Run button is available - I
can't access macro options somehow!


Thanks in advance for any help!

 

[barglen]

I have had the same problem.
found that removing hte password from the spreadsheet meant that the macros
would work.
But that's not really acceptable I reckon.
Have raised the question in a separate entry - no answer as yet.

 

[Ron de Bruin]

See
http://www.rondebruin.nl/password2007.htm

 

[Arvi Laanemets]

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)

 

[Ron de Bruin]

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.

 

[Arvi Laanemets]

Hi

I use only worksheet protection and VBA Project protection.

But all my workbooks are created in Excel2000, and must remain in Excel2000
format - I'm not sure how good is compatibility with earlyer versions in
Excel2007.

I have encountered a couple other problems too with Exce2000 files. I posted
them in microsoft.excel.programming:
"Excel2000 procedure in Excel2007" at April 14.
"Excel2000 worksheet Change event doesn't work in Excel2003 or higher" and
"Excel 2000 vs 2003 date format issue (reposted)" at April 29.

I did get workbook working properly in Excel2003 (simply redesigning the
workbook from scratch, without any changes), but with Excel2007 it doesn't
work properly jet. Yesterday I added password removing (as all sheets in
workbook are protected, I got an idea from current post, that maybe this is
the cause for problems) into Change event, but it didn't have any effect.