+ Reply to Thread
Results 1 to 4 of 4

Unable to Edit Userform, unable to resize, move any objects, unable to right click

  1. #1
    Registered User
    Join Date
    10-31-2012
    Location
    Las Vegas
    MS-Off Ver
    Excel:Mac 2011
    Posts
    3

    Unable to Edit Userform, unable to resize, move any objects, unable to right click

    I created a user form and everything worked great. One day I needed to add an extra tab in a tabstrip on my user form. Thats when I noticed I'm unable to right click anywhere on the user form. I'm unable to add tabs to a tabstrip, unable to rename the tabs, unable to resize objects or move them. It's as if the workbook was locked to prevent editing. I tried going into the tools on the menu and unprotecting the workbook and that doesn't work. Please help, thank you.
    Last edited by barteklv; 10-31-2012 at 03:50 PM.

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Unable to Edit Userform, unable to resize, move any objects, unable to right click

    Hi

    I dont have or ever used your version of excel but from your description you are trying to amend your userform from the worksheet I doubt that will ever work. You need to enter VBA and edit your userform from there. Sorry if I have read your description wrong.

    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    10-31-2012
    Location
    Las Vegas
    MS-Off Ver
    Excel:Mac 2011
    Posts
    3

    Re: Unable to Edit Userform, unable to resize, move any objects, unable to right click

    Thanks for everyone taking a look at it. One day it just started working. Weird!

  4. #4
    Registered User
    Join Date
    10-10-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003, 2007 & 2010
    Posts
    88

    Re: Unable to Edit Userform, unable to resize, move any objects, unable to right click

    Get yourself a PC :-)

+ 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