|
Disable command bar Excel 2007 and Vista
Hello All,
My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Hi Josh
Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Hi Ron,
Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Hi Josh
The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
I Know this has been a long time ago, but i was taken off the project ofr a
while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Hi Josh
The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
when i password protect my file on office 07, it disables the marcos the next
time i open the file. how do i do both, i need the file password protected and the marcos to run in order for the program to work correctly "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
sorry, i should have put these questions together. anyway i have gotten my
file to open in the custom ui, but it does not seem to effect the file. i am using your example to disable menu bars like print preview. do i really need to insert a icon? when i when i validate the file, i get an error that says "Not a valid XML document! Data at the root level is invalid. Line 1, position 1." I copied the exampe right from the "XML Samples -- XL Disable Controls.xml. what does the first line mean? almost looks like it is a path to some where? "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
----------------------- Posted by Jim Rech. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypass*EncryptedMacroScan set to 1. ---------------------------------------------------------------------------*-------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins (Use old Classic Menu of Office-2003 in Office-2007) "Josh C" wrote in message ... when i password protect my file on office 07, it disables the marcos the next time i open the file. how do i do both, i need the file password protected and the marcos to run in order for the program to work correctly "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
the register has to changed on each computer?
"Shah Shailesh" wrote: ----------------------- Posted by Jim Rech. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassÂ*EncryptedMacroScan set to 1. ---------------------------------------------------------------------------Â*-------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins (Use old Classic Menu of Office-2003 in Office-2007) "Josh C" wrote in message ... when i password protect my file on office 07, it disables the marcos the next time i open the file. how do i do both, i need the file password protected and the marcos to run in order for the program to work correctly "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Ok i found a example that works to diable the most of the file menus except
the publish menu, it does not. why is that one different? Also, the Page Layout Tab and the PDF tabs do not disable when the I use the '<tab idMso="TabPageLayout" visible="false" /' if I put a space bewteen Page and Layout, when I get an error, if I don't there is no error, but it does not disable. Any thoughts "Josh C" wrote: sorry, i should have put these questions together. anyway i have gotten my file to open in the custom ui, but it does not seem to effect the file. i am using your example to disable menu bars like print preview. do i really need to insert a icon? when i when i validate the file, i get an error that says "Not a valid XML document! Data at the root level is invalid. Line 1, position 1." I copied the exampe right from the "XML Samples -- XL Disable Controls.xml. what does the first line mean? almost looks like it is a path to some where? "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
There are dictator examples in the examples on my site Josh
http://www.rondebruin.nl/ribbon.htm Download the examples (2) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Ok i found a example that works to diable the most of the file menus except the publish menu, it does not. why is that one different? Also, the Page Layout Tab and the PDF tabs do not disable when the I use the '<tab idMso="TabPageLayout" visible="false" /' if I put a space bewteen Page and Layout, when I get an error, if I don't there is no error, but it does not disable. Any thoughts "Josh C" wrote: sorry, i should have put these questions together. anyway i have gotten my file to open in the custom ui, but it does not seem to effect the file. i am using your example to disable menu bars like print preview. do i really need to insert a icon? when i when i validate the file, i get an error that says "Not a valid XML document! Data at the root level is invalid. Line 1, position 1." I copied the exampe right from the "XML Samples -- XL Disable Controls.xml. what does the first line mean? almost looks like it is a path to some where? "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Thanks for all your help Ron,
I found your examples, and they worked for everything but the Excel Options button on the Office Menu. I have tried: <command idMso="FileExcelServicesOptions" enabled="false" / and <tab idMso="TabOfficeMenu" <group idMso="FileExcelServicesOptions" visible="false" / </tab but neither seem to disable the button. I would be very greatful if you could find my error!!! "Ron de Bruin" wrote: There are dictator examples in the examples on my site Josh http://www.rondebruin.nl/ribbon.htm Download the examples (2) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Ok i found a example that works to diable the most of the file menus except the publish menu, it does not. why is that one different? Also, the Page Layout Tab and the PDF tabs do not disable when the I use the '<tab idMso="TabPageLayout" visible="false" /' if I put a space bewteen Page and Layout, when I get an error, if I don't there is no error, but it does not disable. Any thoughts "Josh C" wrote: sorry, i should have put these questions together. anyway i have gotten my file to open in the custom ui, but it does not seem to effect the file. i am using your example to disable menu bars like print preview. do i really need to insert a icon? when i when i validate the file, i get an error that says "Not a valid XML document! Data at the root level is invalid. Line 1, position 1." I copied the exampe right from the "XML Samples -- XL Disable Controls.xml. what does the first line mean? almost looks like it is a path to some where? "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
so, i looked in the register and could only get this far:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ there was no folder called: ExcelBypassÂ*EncryptedMacroScan and then there was a "VBAWarnings" i opened that and the data value is already set to 1, should I set in to zero(0) or am i in the wrong place? there was a default file with (value not set) the only folder was "Trusted Locations" "Shah Shailesh" wrote: ----------------------- Posted by Jim Rech. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassÂ*EncryptedMacroScan set to 1. ---------------------------------------------------------------------------Â*-------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins (Use old Classic Menu of Office-2003 in Office-2007) "Josh C" wrote in message ... when i password protect my file on office 07, it disables the marcos the next time i open the file. how do i do both, i need the file password protected and the marcos to run in order for the program to work correctly "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Jim,
Were you ever able to find the correct path, I would like to be able to Run macros in a password protected file in office 07 Thanks, Josh "Shah Shailesh" wrote: ----------------------- Posted by Jim Rech. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassÂ*EncryptedMacroScan set to 1. ---------------------------------------------------------------------------Â*-------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins (Use old Classic Menu of Office-2003 in Office-2007) "Josh C" wrote in message ... when i password protect my file on office 07, it disables the marcos the next time i open the file. how do i do both, i need the file password protected and the marcos to run in order for the program to work correctly "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
See
http://www.rondebruin.nl/password2007.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Jim, Were you ever able to find the correct path, I would like to be able to Run macros in a password protected file in office 07 Thanks, Josh "Shah Shailesh" wrote: ----------------------- Posted by Jim Rech. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassÂ*EncryptedMacroScan set to 1. ---------------------------------------------------------------------------Â*-------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins (Use old Classic Menu of Office-2003 in Office-2007) "Josh C" wrote in message ... when i password protect my file on office 07, it disables the marcos the next time i open the file. how do i do both, i need the file password protected and the marcos to run in order for the program to work correctly "Ron de Bruin" wrote: Hi Josh The UI editor will only open files that have 2007 format -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... I Know this has been a long time ago, but i was taken off the project ofr a while. i have installed the Custom UI Editor, but it will not open the Excel file (that was started in office 2003) everytime i try, an error pops up that says "File contains corrupted data." where do i start to see what data in corrupted. the program has may Macros, but it will not even open the file to get to the Marco. the file will open fine on its own without Custom UI Editor. "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Ron,
Althought, this discussion was long time ago, but I've just found this recently. I try the ribbon example from you website, but this seems to be the manual step. If I use Custom UI editor manually and insert example it seem to disable the menu command. Can I automate this or do this programatically? Thanks for you help "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
Disable command bar Excel 2007 and Vista
Hi Gary
I am not sure I understand your problem. What do you want to do ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gary Nguyen" wrote in message ... Ron, Althought, this discussion was long time ago, but I've just found this recently. I try the ribbon example from you website, but this seems to be the manual step. If I use Custom UI editor manually and insert example it seem to disable the menu command. Can I automate this or do this programatically? Thanks for you help "Ron de Bruin" wrote: Hi Josh The Custum UI editor is only for the developer to make it easy to add the xml. The xml and the callbacks are only for Excel 2007 in (Win Xp or Vista) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hi Ron, Am I going to need add ins on all computers, or if I just enter the code will it disable the controls on all computers. Also, is this code for Excel 2007 or Vista or does it not matter? "Ron de Bruin" wrote: Hi Josh Follow the steps on my ribbon page There is a example to disable controls http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Josh C" wrote in message ... Hello All, My company has developed a program is Excel 03 that has a lot of security attached to it. I have used Ron de Bruin website to disable most of the toolbars in the programs. Now that I gotten it all done and ready to distribute to our salesman, our computer provider says we should start thinking about upgrading to Vista. We have one computer with Vista on it. Guess what, the disabling of the command bars is not working. I need something like what is on the website: www.rondebruin.nl/menuid.htm so I can adjust the Excel program to work with MS Vista and Office 2007. |
| All times are GMT +1. The time now is 02:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com