Might be that workbook got disabled/blocked by Excel early on.

You have to manually re-enable it.

Excel 2007 : Office buttonExcel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go

If the workbook is listed try to re-enable.


Gord Dibben MS Excel MVP

On Fri, 16 Apr 2010 11:16:15 +0930, "RobN" wrote:

Bob,

I omitted to say that I had already tried that - sorry.

The interesting thing is that I put the file in the same "trusted" folder as
an earlier version of the same file which opens up OK, and with the same
password. The only difference is that the file which does open OK with
macros working, was an xls version, whereas the file that doesn't open with
macros working, is the xlsm version. But converting the xlsm to an xls made
no difference - it still loaded with macros disabled, providing no option to
enable.

I can't simply use the older xls file because I developed it a bit more, as
well as added some more functionality to create the new xlsm file. And I
don't have regular access to the laptop so all the development was done on a
desktop computer.

Rob

"Bob Phillips" wrote in message
...
How about creating a trusted location and putting that file there?

--

HTH

Bob

"RobN" wrote in message
...
I have a workbook which, when opened on a laptop without any virus
protection, will not give me the option to Enable this Content. ie that
option is not even given when the security warning appears.

I found that I had to remove the password from the Excel 2007 xlsm file
and, also turn on the firewall in the Security Centre. The file then
opened with macros functioning - ie it did not come up with the security
warning.

As the laptop is used only for two purposes, neither of which pose a
security risk, and is not connected to the internet, etc., is there a way
to bypass this imposed security as I do want to password protect the
workbook.

Rob