+ Reply to Thread
Results 1 to 2 of 2

Can't run email-macro if sheet is locked

  1. 06-17-2019, 06:44 AM #1
    HereComesTheBoom
    HereComesTheBoom is offline
    Forum Contributor
    Join Date
    04-20-2017
    Location
    SWEDEN
    MS-Off Ver
    2016
    Posts
    123

    Can't run email-macro if sheet is locked

    I run this to deliver a report, but the sheet itself needs to be locked - and then this wont run... can't see why?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 06-17-2019, 06:59 AM #2
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Can't run email-macro if sheet is locked

    have you tried unprotecting sheet and reprotecting. Also this should allow access to sheet from VBA
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Email hyperlink not updating correctly in Locked sheet.
    By Pheo-Blue in forum Excel General
    Replies: 3
    Last Post: 05-20-2017, 11:42 AM
  2. Macro: copy to new sheet that is locked or password protected
    By jstakutis in forum Excel General
    Replies: 7
    Last Post: 03-22-2017, 11:53 AM
  3. [SOLVED] Macro-copy to new sheet with cells still locked
    By jstakutis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2017, 03:36 PM
  4. Email Macro - From excel sheet to Outlook email macro
    By juanes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2013, 01:59 PM
  5. Using a Macro to update locked excel sheet
    By Zunit in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2013, 03:45 AM
  6. Macro to PDF a sheet in workbook and email (outlook) to an email address in a cell
    By paul_sykes00 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-17-2012, 12:54 AM
  7. Locked Sheet - Macro's work - Internet Links Do Not
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2009, 02:33 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1