Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enabling Macros
I have been trying to enable macros in Excel 2007 (recently acquired) and
though I have turned on Enable Macros and VB etc. It will still not let me use them and I continue to get the security warning when the file is opened. Can anyone give me an answer |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enabling Macros
Are you opening files from a previous version? If so, and there is a button
above the spreadsheet about security (forget the exact text) click that and see if they are now enabled. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brian Gregg" wrote in message ... I have been trying to enable macros in Excel 2007 (recently acquired) and though I have turned on Enable Macros and VB etc. It will still not let me use them and I continue to get the security warning when the file is opened. Can anyone give me an answer |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enabling Macros
Yes I am opening files from Excel 2003
Do you mean the words along the lines of: Security macros disabled. If yes, then I do what is suggested and select the enable option, but it still comes up with the warning. "Bob Phillips" wrote: Are you opening files from a previous version? If so, and there is a button above the spreadsheet about security (forget the exact text) click that and see if they are now enabled. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brian Gregg" wrote in message ... I have been trying to enable macros in Excel 2007 (recently acquired) and though I have turned on Enable Macros and VB etc. It will still not let me use them and I continue to get the security warning when the file is opened. Can anyone give me an answer |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Enabling Macros
Yes that's the one. Fid you look at the security options, it says 'Disable
all macros with notification'. I think this means that this is what happens. When you select Enable, the macros work, right? -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brian Gregg" wrote in message ... Yes I am opening files from Excel 2003 Do you mean the words along the lines of: Security macros disabled. If yes, then I do what is suggested and select the enable option, but it still comes up with the warning. "Bob Phillips" wrote: Are you opening files from a previous version? If so, and there is a button above the spreadsheet about security (forget the exact text) click that and see if they are now enabled. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Brian Gregg" wrote in message ... I have been trying to enable macros in Excel 2007 (recently acquired) and though I have turned on Enable Macros and VB etc. It will still not let me use them and I continue to get the security warning when the file is opened. Can anyone give me an answer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 enabling macros | Excel Discussion (Misc queries) | |||
Excel 2007 Enabling Macros | Excel Discussion (Misc queries) | |||
Enabling Macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Worksheet Functions |