MS Excel / VBA help thread

You are reading a single comment by @Sam_w and its replies. Click here to read the full conversation.

•

christianSpaceman in reply to @aggi

Could be wrong, but from memory I don't think you can do the .Send. I think it asks for confimation, which is why you use the Display / SendKeys to send it for you.

•

Sam_w in reply to @christianSpaceman
Could you use .send and disable alerts using
```
Application.DisplayAlerts = False
```

•

Chalfie in reply to @Sam_w

JUst tried that.
nope.
it's something to do with trust centre and something i'm not really recalling properly. But i imagine i need admin rights.

About

Avatar for Sam_w @Sam_w started