| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
enable macros question not being asked when opening file
I have a file with numerous vba functions. I recently copied the file to
model a different scenario but when I open the copied file I am not being asked to "enable Macros", the file is just opening up straight away. My macro security is still set to Medium but now when the file opens up all my macros appear to be disabled and I get #Name? outputs in the cells utilizing the vba functions. Any idea what I've done AND how I fix it? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
enable macros question not being asked when opening file
Check under HelpAbout MS ExcelDisabled Items.
Maybe something in there to re-enable. Why Excel would choose to disable if that's the case......?? Maybe you started up one time in Safe Mode? Gord Dibben MS Excel MVP On Wed, 6 Jun 2007 19:41:01 -0700, Aussie Ells <Aussie wrote: I have a file with numerous vba functions. I recently copied the file to model a different scenario but when I open the copied file I am not being asked to "enable Macros", the file is just opening up straight away. My macro security is still set to Medium but now when the file opens up all my macros appear to be disabled and I get #Name? outputs in the cells utilizing the vba functions. Any idea what I've done AND how I fix it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable/Disbale Macro on opening Excel file | Excel Discussion (Misc queries) | |||
| Macros Disabled when opening file | Excel Discussion (Misc queries) | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| Enable Macros question at Startup | Excel Discussion (Misc queries) | |||
| Opening a file and enabling macros automatically | Excel Discussion (Misc queries) | |||
Linear Mode
