Consulting

Results 1 to 2 of 2

Thread: Is there anyway I can whitelist an excel sheet to send emails via VBA

  1. #1

    Is there anyway I can whitelist an excel sheet to send emails via VBA

    I have a sheet that sends periodic emails but still have to grant it access to send emails by click the Allow button in Outlook if I restart my PC. Is there anyway I can whitelist specific excel sheets as I don't want to allow any old VBA script to run just certain excel sheets.


    thanks

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Const WhiteSheets As String = "Comma, Separate, List, of, Sheet, Names"
    
    If Instr(WhiteSheets, Sheet.Name) > 0 Then 'That's a WhiteListed Sheet
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •