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
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. |
#6
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 |
#7
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 |
#8
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
Nope. Excel wants to look at your file.
Close excel click on the windows start button Click on Run type Regedit and hit ok You should see a right and left hand side in the window that just opened--kind of like Windows explorer. Click on the + in front of each "branch" to open that branch. Start on HKEY_CURRENT_USER (directly under "My Computer" (the top level)) Click on each of these in order: HKCU\Software \Microsoft \Office \12.0 \Excel \Security Once you expand the Excel level, you'll see Security. Rightclick on that Security key Click New... Choose DWord Type this in as the name: ExcelBypassEncryptedMacroScan (I'd cut and paste from this message to avoid typos) Hit enter to finish your name change Doubleclick on that new entry. Change the 1 to 0 and click ok (you don't have to worry about the Base--hexadecimal and decimal don't matter here) You're done. Close this window Start up excel and test it out. ===== Just a warning. Be careful when you do this. You'll notice that there are not many "Are you sure prompts". If you delete something that you shouldn't or change something that you shouldn't, you could screw something up. But with a little bit of care, you should be ok. You may want to make a back up of the registry before you start. You can do this by opening Regedit and then File|Export Export the whole thing (All under the "Export Range" option at the bottom ivo wrote: 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 -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO inside PROTECTED FILE - Please help
that means that if someone does not have AV program, he would not have
problems. No it doesn't. Everyone will have this issue. Excel goes by whether the file can be scanned not whether it will be scanned. To edit the registry: From Start-Run enter "regedit.exe" (no quotes). -- Jim "ivo" wrote in message ... 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 |
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) |