+ Reply to Thread
Results 1 to 1 of 1

Aftersave macro. adding a date to cell when the sheets protected

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    bath
    MS-Off Ver
    Excel 2010
    Posts
    16

    Aftersave macro. adding a date to cell when the sheets protected

    Sorry - i mean beforesave**

    My code is
    Please Login or Register  to view this content.
    Im getting an error as the sheet is protected.

    'run time error 1004

    the cell or chart that you are trying to change is protected therefore read-only
    to modify a protected cell or chart first remove protection....'


    is there a way to unprotect the sheet while this macro runs?

    Thanks!
    Last edited by kjshep; 10-25-2012 at 10:31 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1