Called Code fails to run when assigned to button

[DarrylBurge2]

In the attached workbook I have the following code:

Please Login or Register  to view this content.

This, in turn, is called in this code:

Please Login or Register  to view this content.

If I run this code manually, it runs perfectly, saves the worksheet as PDF, attached to an email and replaces forumals with existing data.
However, I have a picture in cell A1, and I have assigned Email_PDF to this. All of the code runs EXCEPT for DeleteSomeFormulas

stackoverflow.com/questions/79023420/code-doesnt-run-all-elements-when-applied-to-button-does-when-run-manually

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
For new members: you will not be able to post a full URL, so remove the https://www. section and add one or two breaks to the rest of the address. A Moderator or Admin will then fix the link for you.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://stackoverflow.com/questions/...n-run-manually)

[romperstomper]

Change the code to:

Please Login or Register  to view this content.

then call it using:

Please Login or Register  to view this content.

[DarrylBurge2]

then call it using:

Please Login or Register  to view this content.

When I change the call I get a
"Compile Error:
Expected: End of Statement"

[DarrylBurge2]

Line changed to

Please Login or Register  to view this content.

Is that the correct method, as it seems to do what it is supposed to with this change.

[romperstomper]

You should not need to use Call. The original code I posted works.

[DarrylBurge2]

My Apologies, i assumed "Call it using" meant use "Call".

It does work, thank you very much

[DarrylBurge2]

The original code I posted works.

Hi Romper, further testing and the formulas are being stripped out when a new worksheet is being created.

the only time DeleteSomeFormuals is being used is when Email_PDF is run.


Nope, Apologies, I was running a legacy version.