View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Simon Craner Simon Craner is offline
external usenet poster
 
Posts: 1
Default Restricted Access with Macros

Good Day All,

When one restricts access to the Excel Document via Restricted access and
the file contains macros and works within the document before closing it all
is ok.

When you close the document and then reopen, the doc reports restricted
access, but doesn't report macros as being disabled until you attempt to
click on an item which would invoke the macro.
It then states that the macro can't run or is disabled.
We are having this issue on a local machine and the same issue from with
Sharepoint 2003. We even added the trusted locations to the Trust Centre.

Please can someone assist?