+ Reply to Thread
Results 1 to 4 of 4

Copy & Paste option disabled

  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    UAE
    MS-Off Ver
    Excel 2016,office 365
    Posts
    69

    Copy & Paste option disabled

    Dear Extperts,
    When I am using the following code in this workbook module, Copy and Paste option is disabled. Within the sheet is working but sheet to another sheet is not working.kindly advice how can i rectify this.

    Private Sub Workbook_SheetActivate(ByVal Sh As Object)
    If Sh.Name <> "Dashboard" Then
    Application.DisplayFormulaBar = True
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
    Else
    Application.DisplayFormulaBar = False
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
    End If
    End Sub

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Copy & Paste option disabled

    Hi krishnakuma6,

    Can you post your file?
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    08-30-2012
    Location
    UAE
    MS-Off Ver
    Excel 2016,office 365
    Posts
    69

    Re: Copy & Paste option disabled

    Thanks for your reply,herewith I enclosed sample excel sheet, when i copy the date from sheet2 and if i paste the same in sheet 3 is not working.
    Attached Files Attached Files

  4. #4
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: Copy & Paste option disabled

    Hi krishnakuma6,

    Can you advise what you're trying to achieve?

    The Macro is hiding the Toolbar & Ribbon if you select a worksheet called 'Dashboard'.

    This macro is triggered on the event of selecting a worksheet.

    It will continue to run every time a worksheet is selected & won't allow you to do a copy & paste.

    Why don't you get the macro to do the copying or whatever else you need to do.

    Otherwise, run the macro from a button on the worksheet as this will allow you to all the normal functions like copying & pasting.

    Hope this helps.

+ 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. Cut Copy Paste Disabled
    By Sp00gles in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2015, 09:33 AM
  2. How do I copy data from one file to another using VBA when copy/cut/paste disabled
    By osbornedj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2015, 04:24 PM
  3. Copy and paste VBA, which sheet to paste to option?
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-21-2013, 10:07 AM
  4. Under Tools my References option is disabled...
    By Pointspreadpros.com in forum Excel General
    Replies: 0
    Last Post: 07-24-2013, 04:24 PM
  5. VBA code has disabled my paste option
    By slatten in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2012, 07:54 PM
  6. Replies: 0
    Last Post: 03-09-2009, 05:16 AM
  7. option button disabled
    By raw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2006, 03:00 PM

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