Hi all. I have a .xlsm file that I have been using for years. Yesterday I opened it on my Android, through Google Drive, and noticed that the code wouldn't fire. No big deal; I half expected that. But then today I opened it on my PC and the code still won't fire. Somehow opening the file on Android must have messed something up.
I have "Enable all macros" checked under Macro Setting in the Trust Center. I'm using Excel 2016.
Any ideas? Thanks!
Neither Android nor IOS can execute VBA macros, so it's not surprising that the code didn't fire. That said, it's unlikely that's the reason your code won't run.
Check if event handling is enabled.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I'm not seeing that setting. Where is it?
You'd need to go into the Immediate Window and type ?Application.EnableEvents and press Enter. If it comes back false, type Application.EnableEvents = True and press Enter.
It came back true.
That proves two things. Macros are enabled and event handling is enabled.
Suggest you post the code and, ideally, a sample workbook.
It says "You are not allowed to post any kinds of links, images or videos until you post a few times."
I did notice that if I copy and paste the routine into a fresh workbook, it runs. Maybe I need to copy the entire workbook, piece by piece?
You ARE allowed to upload workbooks.
Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Ok, hopefully it's attached. There's only one sheet, Sheet1, and that's where the routine is. I removed all of the code except for one MsgBox alert. The code is supposed to run when any cell value changes.
There is no code, that I can see, in this workbook.
I wish I could post a screen shot. When I open the file, I hit Alt+F11 to open the VBA editor, then I look at the project explorer, and double-click on Sheet1. The code is:
Please Login or Register to view this content.
There is, as Trevor said, no code in the workbook you posted. (It also only has Sheet2, not Sheet1)
Rory
That's very strange. I don't know why it's doing that. I'm just going to post the original file. This workbook is much bigger and more confusing, but if you just go into the Sheet1 code, you'll see an MsgBox command that's not getting run.
Your workbook project appears to be corrupt to me. Most things look wrong in the project explorer - eg no names in brackets after the sheet code names.
Yes, opening on Android seems to have corrupted it. Should I just try to re-create the workbook by copying and pasting, piece-by-piece?
You could export the code, then save the workbook as an xlsx file, then reimport the code and save as xlsm again. I'd also suggest using Form controls or shapes to run your macros, not activex controls.
Well thank you everyone for the help. I have been copying and pasting the important stuff and now I seem to have a working version. Lesson learned - never open a .xlsm file on Android!
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
I have upped your reputations as much as it will let me. I don't want to mark it as solved just yet because I'm still curious how it became corrupted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks