+ Reply to Thread
Results 1 to 4 of 4

Newbie How to delete macro "Private Sub Worksheet_SelectionChange(ByVal Target As Range)<"

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Aliso Viejo, California
    MS-Off Ver
    Excel 2011 Mac
    Posts
    2

    Newbie How to delete macro "Private Sub Worksheet_SelectionChange(ByVal Target As Range)<"

    Hello,

    I have found a macro in a critical sheet that I am using that contains the following code:

    "Private Sub Worksheet_SelectionChange(ByVal Target As Range)<

    End Sub"

    Try as I might, I cannot get rid of it (but I'm new to VBA - day one). I've googled high and low. I have tried a "macro remover macro", just deleting the code, deleting everything between Private Sub and End...no luck...it just pops back up the next time I open the workbook.

    Using Excel 2011 for Mac.

    Can anybody help?

    Thanks.

    Mike

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Newbie How to delete macro "Private Sub Worksheet_SelectionChange(ByVal Target As Rang

    You have to delete these lines too...

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Aliso Viejo, California
    MS-Off Ver
    Excel 2011 Mac
    Posts
    2

    Re: Newbie How to delete macro "Private Sub Worksheet_SelectionChange(ByVal Target As Rang

    I try to delete them, save, delete, save. They just keep coming back. Not sure what else I can do. Maybe someone can take a look at the file...??

    Thanks for your help.

    Regards,
    Mike

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Newbie How to delete macro "Private Sub Worksheet_SelectionChange(ByVal Target As Rang

    Not sure what is happening there

+ 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. Replies: 1
    Last Post: 03-06-2012, 01:19 PM
  2. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    By whitesapphire24 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-28-2011, 05:08 AM
  3. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    By dcdusek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-20-2009, 03:04 PM
  4. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    By tawnee jamison in forum Excel General
    Replies: 0
    Last Post: 04-20-2005, 05:13 PM
  5. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    By Arturo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2005, 03:06 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