hi, I have the code that accompanies the attached spreadsheet model that locks the copy, paste, cut, double click and so on, with the right mouse button and shortcut keys, however, the toolbar excel these functions still remain active. I wish you could show me how well I block access to the toolbar.
Thanks in advance.
Last edited by marreco; 07-02-2012 at 08:04 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Visual basic and Macro dialog.
The ribbon controls require the use if ribbon xml.
Please Login or Register to view this content.
Hi.
you can edit the ribbon?
You will find plenty of information here as well as links to the tools
http://www.rondebruin.nl/ribbon.htm
Hi.
I know this link, I'll try to do something, the problem is my skills are too small.
obrigdo!
Did you check the example file I posted? It have the ribbon xml applied.
I downloaded your file but the option is enabled for example cut!
I still do not understand.
Thank you Andy
I missed the Cut command.
amazing, you should know everything about Excel and VBA etc.
teach me how to do it?
Thank you very much!
Hi.
Andy Pope , can do that with this file?
the password is 'amandaraphaella'
Thank you!
I probably could but that would not help in the long run. What happens when you want the next file doing?
You need to learn how to do it yourself. Did you try any of the tools linked to on Ron's pages?
The process is not complicated, although it may well be new to you. The task can even be done by manually editing and creating the required files via notepad.
Start off with the CustomUI program to see the changes made to your previous file. You can probably just cut and paste that into you new file via the customui editor.
hI.
I have customUI editor installed but I need to know the camandos.
how do I get this posted last file and disable the ribbon which allows COPY, PASTE, CUT?
The code of the file you said to download worked perfectly for what I had in mind, leaving inactive options Macros and Visual Basic developer's guide. However, when I copied the code and threw it to my spreadsheet functions were active. Could you please take a look at my code and try to get to me? One important thing, I'm using two codes that block the functions of copy, paste, double click, cut, etc., cause a kind of completed each other and also calls them 'cause a password to open the VBA and Macros executor and, perhaps it is not leaving inactive options on the toolbar.
Thank you!!!
I opened my example file and your latest workbook in CustomUI editor.
The following was in my file.
Your's had nothing.Please Login or Register to view this content.
It has nothing to do with the VBA code instead it is to do with the ribbon xml.
Hi.
I open the Custom UI Editor then I selected my post # 10 file, enter your code.
After opening my file did not work!
Can you see the xml in this file?
I downloaded the file and now my autofill when clicking a cell with the mouse does not work in all my other files. How do I restore it back to the settings I had before.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
File > Options > Advanced > Editing options > Enable fill handle...
Hi. Andy Pope
I managed to make it work, thanks!
some part of the extension (customUI14.xml), was different then I changed and it worked.
thank you!
Last edited by marreco; 07-02-2012 at 08:11 AM.
Can you do this VBA in EnglishOriginally Posted by Andy Pope
Andy Pope and other
You did you deactivate the CUT button on ribbon?
I cleared out all your macro, and the CUT button is still not activated (see attached). I want to learn your secret. Thanks
it's ribbon xml and not vba code.
see post #4 for link with further explanation
how to open VBE in your files ALT + F11 is disa led?
123.xlsxcan u please disable for this one file ??
can u teach me how u doing this?
Sir,
I can still copy paste in the files you claim to have disabled it?
I am doing something similar to this and am sharing the spreadsheet. Does every machine have to have UI editor to run the spreadsheet?
Also, I would like to customize the menu to disable cut copy paste only in 2 of 8 sheets. Is this possible?
Hello Andy Pope. Could you please write cut-copy-paste disabled macro in English? Please!!!
Last edited by akinkaraman; 02-25-2015 at 08:45 PM.
So I downloaded the file (840485.xlsm) a while ago when I was playing with this. I just opened it up again (thinking it was something else), and now everything I open up in excel has all my commands overwritten. HELP!!! How do I "undo" whatever this file has done to overwrite my base Excel's program functions?
Also, opening that file has caused other havock on my system.
1) My Personal.xlsb no longer loads at start up
2) Each time excel opens, it appends the name of the Blank.xlsx file. Where usually it always opens Book1.xlsx, it now opens Book2, the next time it's Book3,...I'm all the way up to Book24 now and it's driving me nuts!!
Please tell me what the hell opening that file (840485.xlsm) has done to my EXCEL!!!! This is driving me nuts! I want my shortcut keys back (ie: ctrl+x)! I want to be able to double click on a cell to edit it's contents! I want my personal macro book to load at startup! And I just want to start with Book1.xlsx for crying out loud!
Someone help. I'm 4 hours in on Google searches on this and I'm getting nowhere. I'm about to delete and reinstall for crying out loud!
Normally, we would tell you to start your own thread with this, but I have asked for help from other senior forum members
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Don't know about the lack of personal.xlsb or workbook naming but the following is a reverse of the code that changed all the settings
Please Login or Register to view this content.
Hello!
Please, how did you block the "copy" button from ribbon.
I could block Ctrl+C & Ctrl+V, also right click Copy&Paste, but never ribbon button.
I did this copying and pasting visual basic instructions because I new at this.
When I downloaded the file you've attached, I can't enter into the visual basic dialog to copy yours
would you mind sharing with me?
thank you!
Martin, welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
and how am I supposed to do that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks