Hi all
I made an excel file with a foolproof design. Disabled right click, cut&paste, customized insert&delete rows, forced paste values when copying cells.
However, there is one possible action that will crash the excel program.
This is when a user copies and then paste special.. with the option transpose ON.
I've been searching every where but they all send me to a link where they want a transpose.
I want to disable it, in my case... Is it even possible?
Thanks.
Disabled cut&pasteDoes not compute. Is it disabled or not?This is when a user copies and then paste special
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
You CAN copy&paste but you CAN'T cut&pasteOriginally Posted by AlvaroSiza
so when the user copy and then paste.. I dont want the user to allow the "transpose" option.
Transpose option are accessible through the ribbon or the quickmenu that a appears when pasting..
Last edited by dye_spinner; 03-12-2013 at 10:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
dye_spinner 
Register To Reply
Bookmarks