View Single Post
  #3   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

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

--

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


"Arvi Laanemets" wrote in message ...
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!

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