Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
I really can't believe it's happening. I have file that is protected form
opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
Hi Ivo,
I password protected an Excel 2007 file containing a macro and have no problem running the macro. Exactly what kind of protection are you putting on? 1. File, Save As, Tool, General Options, Password to Open 2. Review, Sheet Protection 3. Review, Protect Workbook... 4. Review, Share Workbook... -- Thanks, Shane Devenshire "ivo" wrote: I really can't believe it's happening. I have file that is protected form opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
Thanks Shane
i use first of your these you wrote i really cannot understand that because it is stupid. If someone already entered my file, why should not be possible to run macro "ShaneDevenshire" wrote in message ... Hi Ivo, I password protected an Excel 2007 file containing a macro and have no problem running the macro. Exactly what kind of protection are you putting on? 1. File, Save As, Tool, General Options, Password to Open 2. Review, Sheet Protection 3. Review, Protect Workbook... 4. Review, Share Workbook... -- Thanks, Shane Devenshire "ivo" wrote: I really can't believe it's happening. I have file that is protected form opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
Jim Rech posted this:
When a password protected workbook is opened in Excel 2007 macros are automatically disabled, presumably because the macros cannot be scanned due to the file being encrypted. Setting this dword registry key to 1 will turn that feature off: HKCU\Software \Microsoft \Office \12.0 \Excel \Security \ExcelBypassEncryptedMacroScan ivo wrote: Thanks Shane i use first of your these you wrote i really cannot understand that because it is stupid. If someone already entered my file, why should not be possible to run macro "ShaneDevenshire" wrote in message ... Hi Ivo, I password protected an Excel 2007 file containing a macro and have no problem running the macro. Exactly what kind of protection are you putting on? 1. File, Save As, Tool, General Options, Password to Open 2. Review, Sheet Protection 3. Review, Protect Workbook... 4. Review, Share Workbook... -- Thanks, Shane Devenshire "ivo" wrote: I really can't believe it's happening. I have file that is protected form opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
If I only hit refresh before posting! <g
-- Jim "Dave Peterson" wrote in message ... Jim Rech posted this: When a password protected workbook is opened in Excel 2007 macros are automatically disabled, presumably because the macros cannot be scanned due to the file being encrypted. Setting this dword registry key to 1 will turn that feature off: HKCU\Software \Microsoft \Office \12.0 \Excel \Security \ExcelBypassEncryptedMacroScan ivo wrote: Thanks Shane i use first of your these you wrote i really cannot understand that because it is stupid. If someone already entered my file, why should not be possible to run macro "ShaneDevenshire" wrote in message ... Hi Ivo, I password protected an Excel 2007 file containing a macro and have no problem running the macro. Exactly what kind of protection are you putting on? 1. File, Save As, Tool, General Options, Password to Open 2. Review, Sheet Protection 3. Review, Protect Workbook... 4. Review, Share Workbook... -- Thanks, Shane Devenshire "ivo" wrote: I really can't believe it's happening. I have file that is protected form opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
thank you. That is very possible the reason of my problem.
But, that means that if someone does not have AV program, he would not have problems. and please, can you tell me how to reach to this registry? "Jim Rech" wrote in message ... If I only hit refresh before posting! <g -- Jim "Dave Peterson" wrote in message ... Jim Rech posted this: When a password protected workbook is opened in Excel 2007 macros are automatically disabled, presumably because the macros cannot be scanned due to the file being encrypted. Setting this dword registry key to 1 will turn that feature off: HKCU\Software \Microsoft \Office \12.0 \Excel \Security \ExcelBypassEncryptedMacroScan ivo wrote: Thanks Shane i use first of your these you wrote i really cannot understand that because it is stupid. If someone already entered my file, why should not be possible to run macro "ShaneDevenshire" wrote in message ... Hi Ivo, I password protected an Excel 2007 file containing a macro and have no problem running the macro. Exactly what kind of protection are you putting on? 1. File, Save As, Tool, General Options, Password to Open 2. Review, Sheet Protection 3. Review, Protect Workbook... 4. Review, Share Workbook... -- Thanks, Shane Devenshire "ivo" wrote: I really can't believe it's happening. I have file that is protected form opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
I did edit your post--just to avoid any line wrap problems.
Jim Rech wrote: If I only hit refresh before posting! <g -- Jim "Dave Peterson" wrote in message ... Jim Rech posted this: When a password protected workbook is opened in Excel 2007 macros are automatically disabled, presumably because the macros cannot be scanned due to the file being encrypted. Setting this dword registry key to 1 will turn that feature off: HKCU\Software \Microsoft \Office \12.0 \Excel \Security \ExcelBypassEncryptedMacroScan ivo wrote: Thanks Shane i use first of your these you wrote i really cannot understand that because it is stupid. If someone already entered my file, why should not be possible to run macro "ShaneDevenshire" wrote in message ... Hi Ivo, I password protected an Excel 2007 file containing a macro and have no problem running the macro. Exactly what kind of protection are you putting on? 1. File, Save As, Tool, General Options, Password to Open 2. Review, Sheet Protection 3. Review, Protect Workbook... 4. Review, Share Workbook... -- Thanks, Shane Devenshire "ivo" wrote: I really can't believe it's happening. I have file that is protected form opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
MS decided that since an encrpyted file cannot be scanned for viruses they
would just disable macros in them. A registry entry can change this: (Dword) HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassEncryptedMacroScan Set the value to 1. -- Jim "ivo" wrote in message ... Thanks Shane i use first of your these you wrote i really cannot understand that because it is stupid. If someone already entered my file, why should not be possible to run macro "ShaneDevenshire" wrote in message ... Hi Ivo, I password protected an Excel 2007 file containing a macro and have no problem running the macro. Exactly what kind of protection are you putting on? 1. File, Save As, Tool, General Options, Password to Open 2. Review, Sheet Protection 3. Review, Protect Workbook... 4. Review, Share Workbook... -- Thanks, Shane Devenshire "ivo" wrote: I really can't believe it's happening. I have file that is protected form opening and inside the file are macros. My Excel 2007 doesn't allow me to execute these macros when file is protected. The fact that i put my file in folder which I put inside Tructr Center location, but this doesn't help also. Only, when I remove password, everything is OK. Please is there any advice for me? File must have password. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as the Macro Protected File | Excel Discussion (Misc queries) | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
get file name inside a macro on Excel | Excel Worksheet Functions | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro Inside Cell | Excel Discussion (Misc queries) |