• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Freeze pane Disable

Abhijeet

Active Member
Hi

I have this workbook Freeze pane option is disable so i want same way disable Copy Paste option from Home Tab any one can tell me how to do this
 

Attachments

  • FreezePanes Disable.xlsx
    9.2 KB · Views: 6
Hi Abhijeet ,

You need to read and understand all of what is explained here :

http://www.rondebruin.nl/win/s2/win001.htm

If you want to insert RibbonX into a Excel 2007-2016 workbook to change the Ribbon, then it is recommended that you download and install the free Custom UI Editor to make this a lot easier. The download link is given in the above page.

Narayan
 
Thanks Mr. Narayan for the link
As you mentioned first you have to install Custom UI Editor and open it
Open FreezePanes Disable Workbook
Change 'False' To 'True'
Save Changes

Here's the attachment with Custom UI Editor and exe file to explain how to edit your workbook
Hope it will be useful
 

Attachments

  • Test.rar
    730.7 KB · Views: 2
Hi Narayan Sir

I read before but i cant know how to do this so can u please give me disable Copy Paste Option & upload that file
 
Try this
Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon>
        <tabs>
<!-- Set visible to false for the Clipboard group on the Home tab-->
            <tab idMso="TabHome">
                <group idMso="GroupClipboard" visible="false"/>   
            </tab>
        </tabs>
    </ribbon>
</customUI>
 
Narayan Sir

I download but that open in notepad i do not know why that.msi file open in notepad can u pls upload workbook that this option is disable
 
Hi Abhijeet ,

Sorry , but you need to understand it yourself.

This technique modifies an individual component of a .xlsx file ; a .xlsx file is actually an archive of several files , some of which are .xml files , and these are the ones used to store customizations of the Ribbon.

In future , if you wish to disable some other menu item on the Ribbon using this same technique , you will again have to resort to the xml editor ; it is better if you can spend some time to understand this so that you can do it yourself.

Narayan
 
Hi Abhijeet ,

A .msi file is a installer executable file ; your Windows OS is configured to use Notepad to open this kind of file ; this is what you need to change.

Go into Control Panel , Default Programs , Set Associations and scroll down the list till you come to .msi ; change the associated program to open this type of file from Notepad to Windows Installer.

All this navigation and selection may depend on your OS. Read how to associate programs with file types with reference to your Windows OS version , and do what ever is required.

The bottom line is Notepad should not be used to open a .msi file.

Narayan
 
Thanks its work please tell me if any other if i want to disable then if any site code mention then it will help me
 
Back
Top