+ Reply to Thread
Results 1 to 3 of 3

Right Mouse Click Cut,Copy & Paste Options disabled When ST3(Excel Utility) is Open

  1. #1
    Registered User
    Join Date
    04-13-2017
    Location
    India
    MS-Off Ver
    Windows 7
    Posts
    2

    Right Mouse Click Cut,Copy & Paste Options disabled When ST3(Excel Utility) is Open

    Hello!!
    This is a problem that's become a nightmare. When the Service Tax offline utility file(Excel File) is open. The Cut,Copy & Paste options in the Menu Bar and on Right Clicking of the Mouse button get Greyed Out OR Get Disabled and these are not available for use in any other Excel file open. Is the Macros to be blamed? Coz a host of Macros are running when the ST Excel Utility is open. Secondly, even after the ST Excel utility is closed the right click options do not work. Please help.

    Just for the sake of info :: ST3 is an Indian Service Tax Utility Excel file (used to file Service Tax Returns) that has a host of Macros running in the background for which the Enabling the running of Macros and Enabling of ActiveX Controls is a must.

    A Godzillion Thanks in Advance.
    ITRestore
    Last edited by ITRestore; 04-13-2017 at 06:51 AM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Right Mouse Click Cut,Copy & Paste Options disabled When ST3(Excel Utility) is Open

    Yes; its a macro in ST3 that disables cut, copy, paste any time the workbook is activated. The code module is password protected, so you can't disable the offending code without the password.

    This code below will re-Enable cut-copy-paste, but anytime you activate the ST3 workbook, they will be disabled again.

    Please Login or Register  to view this content.
    Last edited by AlphaFrog; 04-13-2017 at 03:18 PM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    04-13-2017
    Location
    India
    MS-Off Ver
    Windows 7
    Posts
    2

    Re: Right Mouse Click Cut,Copy & Paste Options disabled When ST3(Excel Utility) is Open

    Dear AlphaFrog,
    Thanks a lot for taking time to help me out with this and extremely sorry for the delay in responding.
    I shall work on this and revert at the earliest.
    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Open ComboBox using TAB instead of having to use mouse click
    By leopardhawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2013, 01:42 PM
  2. Replies: 0
    Last Post: 03-06-2013, 12:52 PM
  3. [SOLVED] Disabled Insert, Cut, Paste and others from Right click menu
    By ChemistB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2012, 11:37 AM
  4. Disabled Delete and unhide options n right click
    By gmalpani in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-24-2011, 04:12 PM
  5. Replies: 3
    Last Post: 11-23-2005, 01:40 PM
  6. [SOLVED] I want open file for click double mouse
    By I want open file for click double mouse in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-17-2005, 08:05 AM
  7. I want open file excel for click double mouse
    By I want open file for click double mouse in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-17-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1