Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 30th, 2007, 07:16 PM
Registered User
 
Join Date: Jul 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Right click cut/copy problem

Please excuse my lack of knowledge when it comes to coding, but a boss of mine requested I figure out how to disable cut/copy functionality from a workbook.

I inserted some code that I found and now I can't use those functions. Please help!!

 
Old July 31st, 2007, 09:21 AM
Friend of Wrox
 
Join Date: Feb 2007
Posts: 163
Thanks: 0
Thanked 2 Times in 2 Posts
Default

What was the code used? It's hard to diagnose the problem without seeing the problem code.

There are a few things to check:
1) Depending on how it was disabled you may need to re-enable the functionality. Run the code you have reversing the value(s) from false to true.

2) It could be the disable code was pasted into your hidden personal workbook. Try removing it from there if that's the case. Go into code view and look at the code in the Personal.xls project.

3) Does this workbook always run? If so you should try to trap the functionality for just that sheet/workbook.

4) Tried removing the code and it still won't work? Look for other hidden workbooks loading when Excel starts that may contain the code.

Hope this helps some.






Similar Threads
Thread Thread Starter Forum Replies Last Post
how to cut a substring petergoodman XSLT 2 July 17th, 2008 06:29 AM
Form Short cut mateenmohd Access 2 November 20th, 2007 05:30 AM
asp cut crmpicco Classic ASP Basics 5 April 1st, 2005 07:36 AM
cut it up crmpicco VB How-To 1 March 3rd, 2005 01:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.