Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security and macros
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security and macros
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security and macros
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security and macros
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security and macros
Thanks Gord.
I suspect that is not the problem as my copy of the file on my desktop computer, as well as the copy on my flash drive (which I used to transfer to the laptop), both show that nothing is disabled. But I'll check the laptop when I can. An observation: If I put the file in an "untrusted" location (on my desktop), when I open it, the Security Warning appears giving me the option to enable. However, before I enable, when I do as you suggest, there is nothing in the list requiring enabling. I may wrongly deduce then that the Security Warning and any add-ins are unrelated. Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security and macros
I have never figured when and why Excel decides to disable something.
It smells something and just blocks the workbook. I have had it occur in earlier versions of Excel with regular workbooks and with add-ins. Even quarantined my Personal.xls once?? Gord On Sat, 17 Apr 2010 09:21:18 +0930, "RobN" wrote: Thanks Gord. I suspect that is not the problem as my copy of the file on my desktop computer, as well as the copy on my flash drive (which I used to transfer to the laptop), both show that nothing is disabled. But I'll check the laptop when I can. An observation: If I put the file in an "untrusted" location (on my desktop), when I open it, the Security Warning appears giving me the option to enable. However, before I enable, when I do as you suggest, there is nothing in the list requiring enabling. I may wrongly deduce then that the Security Warning and any add-ins are unrelated. Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Security and macros
Yeah....strange indeed.
But thanks for the suggestion to check the add-ins.....didn't realise that was there. Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message ... I have never figured when and why Excel decides to disable something. It smells something and just blocks the workbook. I have had it occur in earlier versions of Excel with regular workbooks and with add-ins. Even quarantined my Personal.xls once?? Gord On Sat, 17 Apr 2010 09:21:18 +0930, "RobN" wrote: Thanks Gord. I suspect that is not the problem as my copy of the file on my desktop computer, as well as the copy on my flash drive (which I used to transfer to the laptop), both show that nothing is disabled. But I'll check the laptop when I can. An observation: If I put the file in an "untrusted" location (on my desktop), when I open it, the Security Warning appears giving me the option to enable. However, before I enable, when I do as you suggest, there is nothing in the list requiring enabling. I may wrongly deduce then that the Security Warning and any add-ins are unrelated. Rob "Gord Dibben" <gorddibbATshawDOTca wrote in message . .. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros and security | Excel Worksheet Functions | |||
Macros security | Excel Discussion (Misc queries) | |||
Macros/Security | Excel Worksheet Functions | |||
Macros/Security Level | Excel Discussion (Misc queries) | |||
Security Levels and Macros | Excel Discussion (Misc queries) |