Error 1004

Copper Contributor

I will be very grateful if you help me.
I have a Mac mini with Sonoma 14.1. Before the update to Sonoma worked everything well without any problem. After update to Sonoma, my Excel file shows error 1004 when I click the button that I created.
I made a pdf button to save the worksheet as pdf to my folder with the name of invoice number. When I click on that button; the error 1004 shows up. I made also a button to save the whole excel file to the same folder with the name of invoice number. This also shows error 1004.

I've found a temporarily solution; when I change the name of my file, and change this also on vba, it works. When I slumber my mac and open after 10-12 hours, I get the same issue and I need to change the name of my folder and on vba again. Sometimes Excel doesn't accept used names. Then I need delete that file, create a new file and use the names again. When I open new file, Excel asks for permission to use that file. I give the permission. After slumbering my mac and after 10-12 hours the error occurs again. 


Could anyone help me please? 

My excel is in Dutch. I will translate.


This is my sheet: PDF button and next to it is just "save as".

Scherm­afbeelding 2023-11-10 om 05.46.54.png

When i click the pdf button;



Scherm­afbeelding 2023-11-10 om 04.55.26.png

An error occurred while printing."

I don't know why it's trying to printing.


Scherm­afbeelding 2023-11-10 om 04.55.34.png


"error 1004"

3) the vba code. First button is save as pdf. Second button is just save as

Scherm­afbeelding 2023-11-10 om 04.55.52.png

Thank you for help.


3 Replies
Try recording a macro when you export the sheet to PDF (File, Export, XPS/PDF button). Once the PDF has been created, stop recording and compare the newly added macro to the one causing the issue.
I did like you said. It just added " ChDir "/Users/NAME/Desktop/FOLDERNAME/" " and the rest is same.
When i save manualy there's no problem. But when i use button it gives same error.
Does it help to add the folder to the trusted folders (if that is something Mac Excel allows you to do that is)