I have an Excel macros that writes to a secondary Excel file and saves it. The macro then tells another program that it can now read from the Excel file.
The problem is that when I save the file it starts syncing with one of the cloud sync programs and the other program can't read it as the...
Hi all,
I'm not sure what I did, but I can't get my excel workbook to open properly, and I get this error.
Run Time error 1004
Method 'worksheets' of object '_Global' failed
I am able to open and unlock VBA, but I can't seem to make anything work.
Hello,
How can I allow to hide sheets in my locked workbook? The code below doesn't work.
I receive Error 1004: Application-defined or object-defined error.
If I unlock my workbook than the code passes.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
For Each ws In ThisWorkbook.Worksheets...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.