how to disassociate vba code from onedrive?

Question

how to disassociate vba code from onedrive?

Stephen Thompson 20

modle1 attempts to: ChDir "C:\Users\sthom\OneDrive\Wordle." i don't have a onedrive account. this code, which i did not write, causes my vba code to hang up while fixing errors in my code. to overcome this hang up i need to save and reload the file.

0 comments

Answer accepted by question author

Damien Pham (WICLOUD CORPORATION) 2,300 Microsoft External Staff Moderator

Hello @Stephen Thompson ,

Thank you for sharing the details. Based on the code shown, this does not appear to be an association between VBA and OneDrive. The macro contains a hard-coded OneDrive folder path:

ChDir "C:\Users\sthom\OneDrive\Wordle"

According to Microsoft’s ChDir statement documentation, ChDir changes the current directory or folder to the path specified in the statement.

Please open the Visual Basic Editor and locate this ChDir line. If the macro does not require a specific working folder, you can remove or comment out the line. Otherwise, replace the OneDrive path with the path of an existing local folder on your computer.

I hope this helps clarify why the macro is referencing OneDrive. If you found my response helpful or informative, I would greatly appreciate it if you could follow this guidance or provide feedback.

Thank you.

Damien Pham (WICLOUD CORPORATION) 2,300 Reputation points Microsoft External Staff Moderator

2026-09-17T09:33:08.72+00:00

Hello @Stephen Thompson ,

Thank you for providing the additional details.

Since the current spreadsheet was created as a copy of the previous version, the VBA project, including the Module1 code and its hard-coded OneDrive path, would also have been copied. The presence of that line does not by itself mean that OneDrive or Microsoft automatically added it.

You should not need to recreate the deleted OneDrive folder solely because of this ChDir statement. Updating or removing the line in the affected workbook, as discussed earlier, should prevent the macro from trying to use a folder that no longer exists. Adding VBA code to other Excel or Word files would not normally add this specific path automatically.

After testing the updated version, could you let me know whether the hang-up still occurs? If the issue has been resolved, please also let me know whether you need any further assistance with this question.

I hope this helps clarify why the macro is referencing OneDrive. If you found my response helpful or informative, I would greatly appreciate it if you could follow this guidance or provide feedback.

Thank you.
Damien Pham (WICLOUD CORPORATION) 2,300 Reputation points Microsoft External Staff Moderator

2026-09-21T06:58:17.7866667+00:00
Hello @Stephen Thompson ,

Thank you for the update. Since you replaced the original OneDrive path with an existing local path, the latest behavior does not appear to be caused by the missing OneDrive folder. It now seems to involve the worksheet event or ActiveX button procedures.

You can try the following troubleshooting steps:

Save a backup copy of the workbook before making further changes.

In the Visual Basic Editor, select Debug > Reset to make sure Excel is not still paused in break mode from an earlier debugging session.

Confirm that Excel events are enabled. If a procedure previously disabled application events and did not restore them after an error, worksheet events such as a cell-change procedure may stop running.

Open the affected worksheet’s code window and verify that the date-change procedure is stored under the correct worksheet, rather than in a standard module. Also confirm that the procedure name and event declaration have not been changed.

Place a breakpoint on the first executable line of the worksheet event. Return to Excel and change the relevant cell normally. This can help determine whether the event is being raised and, if so, where execution stops.

Confirm that Design Mode is turned off before testing the ActiveX button. Then check that the button’s click event is stored in the code module for the worksheet containing the button.

Test the worksheet event and the ActiveX button separately. Temporarily exclude unrelated calculations or procedures so you can identify which action causes Excel to become unresponsive.

If the procedure performs a large number of calculations or cell updates, allow it to finish before concluding that the event did not run. A long-running VBA procedure can make Excel appear unresponsive while the code is still executing.

If the behavior continues, please create a new question because this is now separate from the original OneDrive-path issue. In the new question, please include:

The complete worksheet event procedure

The relevant ActiveX button event procedure

Any error message, error number, or highlighted line

Whether Excel becomes completely unresponsive or only the expected procedure does not run

Whether events are enabled when the problem occurs

The Excel version and build shown under File > Account > About Excel

Whether the same behavior occurs in a small test workbook

Thank you.
Damien Pham (WICLOUD CORPORATION) 2,300 Reputation points Microsoft External Staff Moderator

2026-09-24T10:44:56.5033333+00:00

Hello @Stephen Thompson ,

Have you seen my answer in this post? If you have any question, feel free to reach out. I'm happy to support you.
Damien Pham (WICLOUD CORPORATION) 2,300 Reputation points Microsoft External Staff Moderator

2026-09-28T02:30:04.69+00:00

Hello @Stephen Thompson ,

If you're still interested or have any questions, feel free to reach out whenever it works best for you.

1 additional answer

Your answer

Damien Pham (WICLOUD CORPORATION) 2,300 Reputation points Microsoft External Staff Moderator

2026-09-17T09:33:08.72+00:00

Hello @Stephen Thompson ,

Thank you for providing the additional details.

Since the current spreadsheet was created as a copy of the previous version, the VBA project, including the Module1 code and its hard-coded OneDrive path, would also have been copied. The presence of that line does not by itself mean that OneDrive or Microsoft automatically added it.

You should not need to recreate the deleted OneDrive folder solely because of this ChDir statement. Updating or removing the line in the affected workbook, as discussed earlier, should prevent the macro from trying to use a folder that no longer exists. Adding VBA code to other Excel or Word files would not normally add this specific path automatically.

After testing the updated version, could you let me know whether the hang-up still occurs? If the issue has been resolved, please also let me know whether you need any further assistance with this question.

I hope this helps clarify why the macro is referencing OneDrive. If you found my response helpful or informative, I would greatly appreciate it if you could follow this guidance or provide feedback.

Thank you.
Damien Pham (WICLOUD CORPORATION) 2,300 Reputation points Microsoft External Staff Moderator

2026-09-24T10:44:56.5033333+00:00

Hello @Stephen Thompson ,

Have you seen my answer in this post? If you have any question, feel free to reach out. I'm happy to support you.
Damien Pham (WICLOUD CORPORATION) 2,300 Reputation points Microsoft External Staff Moderator

2026-09-28T02:30:04.69+00:00

Hello @Stephen Thompson ,

If you're still interested or have any questions, feel free to reach out whenever it works best for you.

Answer 1

Barry Schwarz 6,431

Change the statement to

ChDir "C:\Users\sthom\Documents"

or to any other folder you have access to.

Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Stephen Thompson 20 Reputation points

2026-09-15T13:56:34.7933333+00:00

In the process of trying to avoid the 10 minute minimum time required it takes to reload this file (its huge and requires 10+GB in memory) I tried to completely uninstal OneDrive. It takes about 20 minutes if I need to save changes (when I have corrected an error in my VBA code). When uninstalling OneDrive I deleted the the OneDrive user's folder and noticed that it did not contain a Wordle subfolder. The VBA project code in module1 (that I didn't write) must be Microsoft code. My concern is what other files could be affected by deleting the OneDrive user's folder(s). My first encounter of this hang up has been very recent. I added activeX controls to the Wordle spreadsheet several revs ago. I didn't write much code for the activeX controls and may have missed the hang up - if encounterred. I have many personal files in Excel and Word which do not contain VBA code that I wrote. I wonder how many of these files could have VBA project module1 code referencing the user's OneDrive folder that no longer exists. Do I need to add the user's OneDrive folder back to my hard drive? Will other files (Word or Excel) add this reference when I add VBA code to them?
Stephen Thompson 20 Reputation points

2026-09-15T14:47:12.28+00:00

In the process of trying to avoid the 10 minute minimum time required it takes to reload this file (its huge and requires 10+GB in memory) I tried to completely uninstal OneDrive. It takes about 20 minutes if I need to save changes (when I have corrected an error in my VBA code). When uninstalling OneDrive I deleted the the OneDrive user's folder and noticed that it did not contain a Wordle subfolder. The VBA project code in module1 (that I didn't write) must be Microsoft code. My concern is what other files could be affected by deleting the OneDrive user's folder(s). My first encounter of this hang up has been very recent. I added activeX controls to the Wordle spreadsheet several revs ago. I didn't write much code for the activeX controls and may have missed the hang up - if encounterred. I have many personal files in Excel and Word which do not contain VBA code that I wrote. I wonder how many of these files could have VBA project module1 code referencing the user's OneDrive folder that no longer exists. Do I need to add the user's OneDrive folder back to my hard drive? Will other files (Word or Excel) add this reference when I add VBA code to them? The previous version of this file (this file started as a renamed copy of the previous version) has exactly the same path change VBA code in module1. The previous version which has some of my debugged VBA code and runs as expected and has for at least a month. Appearently the path change instruction only tries to execute when error(s) are detected. I don't like to make changes to any operating software without changing the version number. Since the previous version runs I don't intend to fix its non-existant path in module1. I will change the VBA code in module1 for this version of my spreadsheet as you suggested and see if the hang ups go away. I need to make more changes to my VBA code and surely I'll make some new error(s) to test your solution.
Stephen Thompson 20 Reputation points

2026-09-18T21:00:39.1966667+00:00

i changed the path in question to an existing path (the path where i store the Excel file) and i thought this corrected the hang ups. After debugging several errors in my code (and some functionality) that i just added the whole thing hangs up again. one of my subroutines triggers on a date change in a specific cell. after detecting a date change the sub counts prior dates in a range. it displays the count of prior dates in the cell below the new date. this code has functioned properly for months. this is the next rev for my spreadsheet (save a copy with the new name). another is trigged by an activeX pushbutton. this sub is supposed to do some calculations and output the results in several places in the Excel workbook. To troubleshoot this new date change code i change the date to trigger the sub (F8 seems to trigger the first private sub for this worksheet) and i know that the sub did not execute when the count of prior dates doesn't update (i clear the cell expecting the sub to write the new count). when the count doesn't display i know the sub didn't execute. prior to changing the path statement, at least twice the debugger pointed to the path change statement in module1 - it shouldn't be a problem with the revised path. it is beyond frustrating finding what i must do to troubleshoot vba code.