+ Reply to Thread
Results 1 to 2 of 2

cannot delete macro, Unhide is greyed out

Hybrid View

  1. #1
    Registered User
    Join Date
    07-18-2016
    Location
    texas
    MS-Off Ver
    2010
    Posts
    21

    cannot delete macro, Unhide is greyed out

    novice user with the most novice question.

    I have a workbook "August 2016.xlsm" which has several macros (created by others). One macro is "PERSONAL.XLSB!test1" which I want to delete.
    I know that to delete, I must Unhide the Personal Workbook. But right click on a worksheet and Unhide is greyed out.
    I have been googling for some time but all answers are for some other issue, not this one.

    thanks.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,719

    Re: cannot delete macro, Unhide is greyed out

    From the MS website:

    Delete a macro

    Do one of the following:

    Open the workbook that contains the macro that you want to delete.

    If the macro that you want to delete is stored in the personal macro workbook (Personal.xlsb), and this workbook is hidden, do the following to unhide the workbook:

    On the View tab, in the Window group, click Unhide.

    Under Unhide workbooks, click PERSONAL, and then click OK.

    In the Macros in list, select the workbook that contains the macro that you want to delete. For example, click This Workbook.

    In the Macro name box, click the name of the macro that you want to delete.

    Click Delete.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Visible Cells Only - Greyed out "Delete Rows"
    By Kashus in forum Excel General
    Replies: 4
    Last Post: 04-04-2017, 11:22 PM
  2. [SOLVED] Excel 2007 : Delete sheet and Unhide greyed out
    By abhinavn in forum Excel General
    Replies: 2
    Last Post: 04-12-2012, 03:49 PM
  3. Can't Unhide or Delete Macro
    By flebber in forum Excel General
    Replies: 4
    Last Post: 07-25-2010, 08:22 PM
  4. [SOLVED] How do I delete a macro in Excel 2003? Button is greyed out.
    By MG in forum Excel General
    Replies: 3
    Last Post: 08-16-2006, 07:25 PM
  5. Why is my Macro delete key greyed out?
    By rogerjcfinch in forum Excel General
    Replies: 3
    Last Post: 07-22-2006, 01:10 PM
  6. [SOLVED] How do I delete Sheets if "Delete" is greyed out?
    By carriemca in forum Excel General
    Replies: 1
    Last Post: 04-10-2006, 12:35 PM
  7. [SOLVED] unlock hidden rows when 'unhide' is greyed out?
    By xela in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2006, 10:25 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