+ Reply to Thread
Results 1 to 7 of 7

Timestamp Macro Error

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    41

    Timestamp Macro Error

    I am getting an error when I run a macro that places a time stamp on the page, then switches to the first tab, and finally closes after 3 seconds. The pages are protected; however, the cell for the time stamp is not locked or hidden. What am I missing in the following:

    Please Login or Register  to view this content.
    Any help will be greatly appreciated

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Timestamp Macro Error

    Try this....

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    06-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    41

    Re: Timestamp Macro Error

    Still get the error but now it mentions that the sheet is protected. I need keep the protection; the individuals who use it keep screwing up the conditional formatting, data validations, and layouts.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Timestamp Macro Error

    In the below code enter your password here>>"EnterYourPasswordHere"

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    41

    Re: Timestamp Macro Error

    Now I get Object required error 424. Do I need to have the sheet name(s) with the ws.unprotected

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Timestamp Macro Error

    Oopss.... Sorry for the inconvenience

    Try the below code...

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    06-19-2013
    Location
    United States
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    41

    Re: Timestamp Macro Error

    Thank you!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. EXCEL 2010 - VLookup = circular ref error + timestamp
    By persais in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 05:47 PM
  2. [SOLVED] timestamp macro h:mm:ss format error message
    By drsuis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 02:06 PM
  3. When a timestamp doesn't behave as a timestamp
    By mredekopp in forum Excel General
    Replies: 3
    Last Post: 03-07-2011, 03:39 PM
  4. Timestamp help (gets error when sheet is protected)
    By nugundam93 in forum Excel General
    Replies: 1
    Last Post: 05-03-2007, 02:04 AM
  5. [SOLVED] Timestamp Macro
    By alexfthe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2006, 07:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1