+ Reply to Thread
Results 1 to 5 of 5

VBA File grayed out

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    50

    VBA File grayed out

    I was trying to walk an associate in to make a changes to some macros I wrote. I tried to get her to go to the VB Editor and edit code (I gave her the password I set for the file). She said she enabled macros when she opened file. She can go there, but everything is grayed out. What could be the problem?

    TIA!

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: VBA File grayed out

    Please attach your file...
    You dont have to show all macros or data when you post your file...
    So, lets check your file...
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  3. #3
    Forum Contributor
    Join Date
    10-13-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2007
    Posts
    401

    Re: VBA File grayed out

    She opened the Excel file and it was read only?

  4. #4
    Registered User
    Join Date
    10-10-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: VBA File grayed out

    I had her check properties in Windows and it is not read only. She sent me the file, and I found I had the same issue. I found if I recorded a macro and stopped it, things magically started working. For future reference, do you know what was going on? I originally sent this file to her for edits to the sheets themselves?

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,820

    Re: VBA File grayed out

    Try the following:
    From File >> Save As >> and save the file with a new name and set the path or location of save

+ 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: 11-30-2013, 06:37 AM
  2. Can't enter data, save, start new file, and most options are grayed out.
    By windsorwindsor1 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-25-2012, 04:26 PM
  3. [SOLVED] Recently used file list is grayed out, why?
    By MrBill in forum Excel General
    Replies: 1
    Last Post: 12-05-2005, 10:35 AM
  4. File-Save is grayed out for periods of time in Excel 2003
    By Ned Grubb in forum Excel General
    Replies: 1
    Last Post: 06-14-2005, 05:05 PM
  5. [SOLVED] Excell2003 (SP-1) File > Save and File > Save As.. grayed out
    By Joe Murphy in forum Excel General
    Replies: 0
    Last Post: 03-09-2005, 06: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