+ Reply to Thread
Results 1 to 2 of 2

Trying to hide a textbox if the worksheet is not protected

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    87

    Trying to hide a textbox if the worksheet is not protected

    i have a textbox on a worksheet that i only want to be visible if one successfully unprotects the sheet (password protected).
    My code is shown below but i get an error when i try to run it - "method oleobjects of object _worksheet failed"

    What could i be doing wrong?

    Please Login or Register  to view this content.





    Thanks

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Trying to hide a textbox if the worksheet is not protected

    Two suggestions:

    You've got TExtbox, do you mean Textbox?

    Try using wsdetail.shapes("Textbox 9") instead of OLEobjects

    What happens if you use the macro recorder to change the textbox?

+ 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. VBA - Macro Code to copy textbox text to another worksheet textbox
    By nitram lowm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2013, 08:39 AM
  2. Macro to copy textbox data to a duplicate textbox in another worksheet
    By nitram lowm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2013, 06:10 AM
  3. Hide command button if worksheet is protected
    By PRodgers4284 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-05-2009, 07:32 AM
  4. [SOLVED] Unprotect a textbox in a protected worksheet
    By RSchatzman in forum Excel General
    Replies: 1
    Last Post: 04-24-2006, 07:35 PM
  5. Hide (limit viewers) to column(s) on a protected worksheet.
    By RAINCITY.1788 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2005, 07:05 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