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!
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
She opened the Excel file and it was read only?
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?
Try the following:
From File >> Save As >> and save the file with a new name and set the path or location of save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks