Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Lock Textbox From Being Changed

  1. #1
    Join Date
    22nd July 2005
    Location
    Wisconsin, USA
    Posts
    16

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    9th September 2006
    Location
    Cheshire-UK
    Posts
    457

    Re: Lock Textbox From Being Changed

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

    Regards,
    Simon

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    22nd July 2005
    Location
    Wisconsin, USA
    Posts
    16

    Re: Lock Textbox From Being Changed

    Just needed to do this...thanks though!

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

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 2
    Last Post: May 7th, 2008, 14:43
  2. Copy Textbox Text When Cursor Moved From Textbox
    By senarumugam2003 in forum EXCEL HELP
    Replies: 5
    Last Post: February 7th, 2007, 21:14
  3. Lock a Textbox from moving while scrolling
    By Jeff P in forum EXCEL HELP
    Replies: 10
    Last Post: August 15th, 2006, 16:19
  4. Run a function whenever a textbox is changed
    By westwood in forum EXCEL HELP
    Replies: 6
    Last Post: August 11th, 2005, 01:56
  5. Replies: 6
    Last Post: October 29th, 2004, 01:52

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
  •  
porno