send an email with macro button, with macros disabled in emailed copy

[davidbananas999]

im trying to use this macro, assigned to a button on the current sheet, to email the current sheet, but in a way that it can be viewed on a mobile device. (macros and form controls disabled in sent version)

Please Login or Register  to view this content.

[davidbananas999]

or is there a way to do something like

Please Login or Register  to view this content.

to select all the ranges without form control?

[Kyle123]

If you export it as xlsx then it should be fine, you don't need to do anything special for it to be viewable on mobile