Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
I want to do "Recent Documents" and "Excel Options" on right side of
Officemenu to non-display. Is there a method? Please teach me. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
Tools - OPtions - General
Deselect recently used file list "MK" wrote: I want to do "Recent Documents" and "Excel Options" on right side of Officemenu to non-display. Is there a method? Please teach me. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
Thank you.
And, I want to do "Excel option" to non-display. "Barb Reinhardt" wrote: Tools - OPtions - General Deselect recently used file list "MK" wrote: I want to do "Recent Documents" and "Excel Options" on right side of Officemenu to non-display. Is there a method? Please teach me. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
Tools-Options-View tab and uncheck 'Startup Task Pane'
Regards, OssieMac "MK" wrote: Thank you. And, I want to do "Excel option" to non-display. "Barb Reinhardt" wrote: Tools - OPtions - General Deselect recently used file list "MK" wrote: I want to do "Recent Documents" and "Excel Options" on right side of Officemenu to non-display. Is there a method? Please teach me. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
Tools - OPtions - General
No such thing in Excel 2007. While you can set the number of files to display under Excel Options in Excel 2007, when you set it to zero, that wipes out the user's MRU list. So if this setting is reset later there are no files there. Users will not thank you for this. This is no way to block this list from appearing short of zeroing it out. You can disable the list by Application.DataEntryMode=True (or xlStrict). This also disables Excel Options and is the only way to do that, as far as I know. -- Jim "Barb Reinhardt" wrote in message ... | Tools - OPtions - General | Deselect recently used file list | | | "MK" wrote: | | I want to do "Recent Documents" and "Excel Options" on right side of | Officemenu to non-display. | Is there a method? | Please teach me. | |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
Thank you very much.
I was able to solve it. "Jim Rech" wrote: Tools - OPtions - General No such thing in Excel 2007. While you can set the number of files to display under Excel Options in Excel 2007, when you set it to zero, that wipes out the user's MRU list. So if this setting is reset later there are no files there. Users will not thank you for this. This is no way to block this list from appearing short of zeroing it out. You can disable the list by Application.DataEntryMode=True (or xlStrict). This also disables Excel Options and is the only way to do that, as far as I know. -- Jim "Barb Reinhardt" wrote in message ... | Tools - OPtions - General | Deselect recently used file list | | | "MK" wrote: | | I want to do "Recent Documents" and "Excel Options" on right side of | Officemenu to non-display. | Is there a method? | Please teach me. | |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
However, data cannot be input.
How should I do to be able to input data, and to disables it? "MK" wrote: Thank you very much. I was able to solve it. "Jim Rech" wrote: Tools - OPtions - General No such thing in Excel 2007. While you can set the number of files to display under Excel Options in Excel 2007, when you set it to zero, that wipes out the user's MRU list. So if this setting is reset later there are no files there. Users will not thank you for this. This is no way to block this list from appearing short of zeroing it out. You can disable the list by Application.DataEntryMode=True (or xlStrict). This also disables Excel Options and is the only way to do that, as far as I know. -- Jim "Barb Reinhardt" wrote in message ... | Tools - OPtions - General | Deselect recently used file list | | | "MK" wrote: | | I want to do "Recent Documents" and "Excel Options" on right side of | Officemenu to non-display. | Is there a method? | Please teach me. | |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
The way you use Application.DataEntryMode is to first make sure all the
input cells have the Locked format removed. Then you have to select the input range (the range you want the user to be able to roam about), and then you set the mode. If you set it to True users can press Esc to exit DEM. If you set it to xlStrict they cannot however you must give them (or yourself) a way to exit DEM (Application.DataEntryMode=False). This is very old technology. The EnableSelection and ScrollArea methods introduced in Excel 97 were supposed to supercede it. But without DEM there is no way to disable Excel Options or the Recent Documents list (as far as I know). MS did not do developers a favor. -- Jim "MK" wrote in message ... However, data cannot be input. How should I do to be able to input data, and to disables it? "MK" wrote: Thank you very much. I was able to solve it. "Jim Rech" wrote: Tools - OPtions - General No such thing in Excel 2007. While you can set the number of files to display under Excel Options in Excel 2007, when you set it to zero, that wipes out the user's MRU list. So if this setting is reset later there are no files there. Users will not thank you for this. This is no way to block this list from appearing short of zeroing it out. You can disable the list by Application.DataEntryMode=True (or xlStrict). This also disables Excel Options and is the only way to do that, as far as I know. -- Jim "Barb Reinhardt" wrote in message ... | Tools - OPtions - General | Deselect recently used file list | | | "MK" wrote: | | I want to do "Recent Documents" and "Excel Options" on right side of | Officemenu to non-display. | Is there a method? | Please teach me. | |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
Thank you.
I used xlStrict. but, Unlocked-cell cannot be selected. And,when returning up after it scrolls below, The Row-numberstring is out of order. A B C D E ... 1 2 3 20 <- Why? 21 <- Why? 6 7 .. And, when worksheet is changed, it becomes xlOff without permission. I confirmed "DataEntryMode" by Excel help documents. And, You are right but, it did not operate like help. Is this Bug? I tried below sourcecode. -----Code for test - start------------ Private Sub Workbook_Open() With Sheet1 .Unprotect .Range("A1:B10").Locked = False .EnableSelection = xlUnlockedCells .Protect userinterfaceonly:=True End With Application.DataEntryMode = xlStrict End Sub -----Code for test - end------------ "Jim Rech" wrote: The way you use Application.DataEntryMode is to first make sure all the input cells have the Locked format removed. Then you have to select the input range (the range you want the user to be able to roam about), and then you set the mode. If you set it to True users can press Esc to exit DEM. If you set it to xlStrict they cannot however you must give them (or yourself) a way to exit DEM (Application.DataEntryMode=False). This is very old technology. The EnableSelection and ScrollArea methods introduced in Excel 97 were supposed to supercede it. But without DEM there is no way to disable Excel Options or the Recent Documents list (as far as I know). MS did not do developers a favor. -- Jim "MK" wrote in message ... However, data cannot be input. How should I do to be able to input data, and to disables it? "MK" wrote: Thank you very much. I was able to solve it. "Jim Rech" wrote: Tools - OPtions - General No such thing in Excel 2007. While you can set the number of files to display under Excel Options in Excel 2007, when you set it to zero, that wipes out the user's MRU list. So if this setting is reset later there are no files there. Users will not thank you for this. This is no way to block this list from appearing short of zeroing it out. You can disable the list by Application.DataEntryMode=True (or xlStrict). This also disables Excel Options and is the only way to do that, as far as I know. -- Jim "Barb Reinhardt" wrote in message ... | Tools - OPtions - General | Deselect recently used file list | | | "MK" wrote: | | I want to do "Recent Documents" and "Excel Options" on right side of | Officemenu to non-display. | Is there a method? | Please teach me. | |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
About Officemenu(RibbonX)
I'm sorry.
And, I am shameful. It is necessary to select cells. My hope can be achieved. Thank you. "MK" wrote: Thank you. I used xlStrict. but, Unlocked-cell cannot be selected. And,when returning up after it scrolls below, The Row-numberstring is out of order. A B C D E ... 1 2 3 20 <- Why? 21 <- Why? 6 7 .. And, when worksheet is changed, it becomes xlOff without permission. I confirmed "DataEntryMode" by Excel help documents. And, You are right but, it did not operate like help. Is this Bug? I tried below sourcecode. -----Code for test - start------------ Private Sub Workbook_Open() With Sheet1 .Unprotect .Range("A1:B10").Locked = False .EnableSelection = xlUnlockedCells .Protect userinterfaceonly:=True End With Application.DataEntryMode = xlStrict End Sub -----Code for test - end------------ "Jim Rech" wrote: The way you use Application.DataEntryMode is to first make sure all the input cells have the Locked format removed. Then you have to select the input range (the range you want the user to be able to roam about), and then you set the mode. If you set it to True users can press Esc to exit DEM. If you set it to xlStrict they cannot however you must give them (or yourself) a way to exit DEM (Application.DataEntryMode=False). This is very old technology. The EnableSelection and ScrollArea methods introduced in Excel 97 were supposed to supercede it. But without DEM there is no way to disable Excel Options or the Recent Documents list (as far as I know). MS did not do developers a favor. -- Jim "MK" wrote in message ... However, data cannot be input. How should I do to be able to input data, and to disables it? "MK" wrote: Thank you very much. I was able to solve it. "Jim Rech" wrote: Tools - OPtions - General No such thing in Excel 2007. While you can set the number of files to display under Excel Options in Excel 2007, when you set it to zero, that wipes out the user's MRU list. So if this setting is reset later there are no files there. Users will not thank you for this. This is no way to block this list from appearing short of zeroing it out. You can disable the list by Application.DataEntryMode=True (or xlStrict). This also disables Excel Options and is the only way to do that, as far as I know. -- Jim "Barb Reinhardt" wrote in message ... | Tools - OPtions - General | Deselect recently used file list | | | "MK" wrote: | | I want to do "Recent Documents" and "Excel Options" on right side of | Officemenu to non-display. | Is there a method? | Please teach me. | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy RibbonX toanother computer | Excel Discussion (Misc queries) | |||
Extend Excel C API add-in for using RibbonX API | Excel Programming | |||
RibbonX and a "macro may not be available" head-scratcher | Excel Programming |