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.

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" <(E-Mail Removed)> wrote in message news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
> 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.
>

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" <(E-Mail Removed)> wrote in message news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
> > 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.
> >
>

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" <(E-Mail Removed)> wrote in message news:A23998FC-0ABA-4295-95A6-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
>> > 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.
>> >
>>

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" <(E-Mail Removed)> wrote in message news:A23998FC-0ABA-4295-95A6-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
> >> > 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.
> >> >
> >>
>

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" <(E-Mail Removed)> wrote in message news:3B366207-628C-4CDB-86D4-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message news:A23998FC-0ABA-4295-95A6-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
>> >> > 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.
>> >> >
>> >>
>>

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" <(E-Mail Removed)> wrote in message news:3B366207-628C-4CDB-86D4-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message news:A23998FC-0ABA-4295-95A6-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
> >> >> > 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.
> >> >> >
> >> >>
> >>
>

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" <(E-Mail Removed)> wrote in message news:3B366207-628C-4CDB-86D4-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message news:A23998FC-0ABA-4295-95A6-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
> >> >> > 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.
> >> >> >
> >> >>
> >>
>

-----------------------
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\Excel\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" <(E-Mail Removed)> wrote in message
news:53086202-84C6-4976-A9B0-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:3B366207-628C-4CDB-86D4-(E-Mail Removed)...
>> >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" <(E-Mail Removed)> wrote in message
>> >> news:A23998FC-0ABA-4295-95A6-(E-Mail Removed)...
>> >> > 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" <(E-Mail Removed)> wrote in message
>> >> >> news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
>> >> >> > 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.
>> >> >> >
>> >> >>
>> >>
>>

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\Excel\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" <(E-Mail Removed)> wrote in message
> news:53086202-84C6-4976-A9B0-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:3B366207-628C-4CDB-86D4-(E-Mail Removed)...
> >> >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" <(E-Mail Removed)> wrote in message
> >> >> news:A23998FC-0ABA-4295-95A6-(E-Mail Removed)...
> >> >> > 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" <(E-Mail Removed)> wrote in message
> >> >> >> news:A13E97D3-906A-46C0-9AC2-(E-Mail Removed)...
> >> >> >> > 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.
> >> >> >> >
> >> >> >>
> >> >>
> >>
>
>
>