Announcement

Collapse
No announcement yet.

Lock Textbox From Being Changed

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Lock Textbox From Being Changed



    Good day,

    I have a form in a workbook that has macros attached via buttons. The intention is that as you hit the revise button it creates a virtually identical sheet, renaming it as a copy in the same workbook, clearing certain fields...etc...I then have it "lock/protect" the previous revision sheet so the history can't easily be corrupted. Everything works with the exception of the forms textbox...it won't lock (more to the point I can't figure out how to lock it). Can you protect a forms textbox even?

    Thanks in advance
    Aaron

  • #2
    Re: Lock Textbox From Being Changed

    Hi, Right click the TextBox and choose properties and change the Locked property to True!

    Regards,
    Simon
    Regards,
    Simon

    In the unlikely event you don't get an answer here try Microsoft Office Help for FREE!
    Please take the time to read these rules before posting!

    Comment


    • #3


      Re: Lock Textbox From Being Changed

      Just needed to do this...thanks though!

      Code:
      With ActiveSheet.TextBoxes
              ActiveSheet.TextBoxes.Locked = True
              ActiveSheet.TextBoxes.LockedText = True
      End With

      Comment

      Working...
      X