View Full Version : [SOLVED:] All macros quit working
kwesmc
08-01-2024, 10:46 AM
For some reason my macros quit working. I get this message: The macros in this project are disabled. Please refer to online documentation....
In my trust center settings, all settings are correct, and of course macros are enabled. The only thing I have done since I last used this Excel file is I went on Excel for the web just to look around at that.
Please help. I am desperate!!
Thanks in advance, Ken Mc
Aflatoon
08-02-2024, 01:20 AM
If you locate the file in Explorer, right-click it and choose properties, is there an option to unblock it?
kwesmc
08-02-2024, 09:15 AM
Thanks. Yes, that was indeed there and I unblocked it. However, now when I run my code, I get an error message 76, "Path not found". It has always worked before, so now I am stumped. Here is the line of code
kwesmc
08-02-2024, 09:17 AM
Sorry, here is the line of code:
ChDir "C:\Users\Administrator\Desktop"
Aflatoon
08-03-2024, 04:55 AM
If the current drive isn't the C: drive, that won't work. You need a ChDrv statement first, although using ChDir or ChDrv is very rarely necessary.
kwesmc
08-03-2024, 11:34 AM
That wasn't the problem. I finally figured out that for some reason, my "Desktop" directory was missing from "C:\Users\Administrator\Desktop". I've never had that happen before. I have no idea how that happened. Weird!!
I put directory back, and now the code is working as it should.
Thanks for your help!
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.