View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default Office Open XML Format?

Why can you not save as an xlsm? (Which is effectively why you are getting
the message)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/
"jfisk" wrote in message
...
In Excel 2007 we get the following warning:
This document is both encypted and password protected. The Office Open
XML
Formats available in the 2007 release provide stronger encryption. Do you
want to increase the security of this document by converting to an Office
Open XML format?
YES / NO

How can I get rid of his? The file has a macro with hard set paths to the
file name so I cannot save this in XLSX format or the macro will fail (and
I
would rather not rewrite the macro, as I have 50 people using this same
sheet). Something in the registry perhaps?