dcsimg
Results 1 to 5 of 5

Thread: [RESOLVED] Excel: How To: Switch between control Edit & Operate modes ???

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Resolved [RESOLVED] Excel: How To: Switch between control Edit & Operate modes ???

    Esteemed Forum Participants and Lurkers:
    ===============================
    Excel 2003

    Does anyone remember the shortcut to switch modes in Excel from Editing controls (standard VBA buttons and stuff) to Operating controls, and back again? I seem to remember that there were keyboard shortcut codes to easily switch back and forth, but my "cerebro viejo" just can't hack it right now.
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: Excel: How To: Switch between control Edit & Operate modes ???

    Click View/Toolbars and make sure Visual Basic is checked.

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: Excel: How To: Switch between control Edit & Operate modes ???

    Thanks Hack ...

    That's close. It certainly de-activates the "operate" function. When in the "Design" mode, I still can't click on a button to select it for editing the properties, such as dragging the borders for size, editing the caption, etc. I can do it the long way, but I'm in a project right now where it sure would be nice to know the shortcut. I'm working on standard VBA buttons in the Excel "Control Toolbox" ... not the 'X' controls.
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

  4. #4

    Thread Starter
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: Excel: How To: Switch between control Edit & Operate modes ???

    THE SHEET WAS PROTECTED !!! When I unlocked the sheet it works FINE. Thanks for the help, Hack!
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

  5. #5
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: [RESOLVED] Excel: How To: Switch between control Edit & Operate modes ???

    Ahhhh....that happened to me once with a SHARED worksheet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width