Solved

Edit text command button

Posted on 2011-03-11
5
2,058 Views
Last Modified: 2012-05-11
Experts,
On my spreadsheet I have numerous form command buttons with different labels. I need to change the lables so I right click on the command button and select Edit Text. There is no cursor but I can delete and change the name but not until I exit text do I see the changes. I thought I could Edit Text seeing the changes while editing>
0
Comment
Question by:Frank Freese
  • 3
  • 2
5 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35110167
I can't replicate that. Can you post a small sample showing the problem?
0
 

Author Comment

by:Frank Freese
ID: 35110241
you bet . . . .
On the first tab "Monthly Total" there is a command button titled "Save & Exit" - that edit's fine. But all buttons labeled Goto or Recon do not (ignore all other command buttons in other columns - they are going away).
There a frozen columns and rows - maybe that's the problem?
1392-Mem-Expenses-03-11Revision.xlsm
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 35110281
Yep - unfreeze panes and then it's fine. Not a bug I'd heard of before.
0
 

Author Comment

by:Frank Freese
ID: 35110337
great - you got educated.....thanks again
0
 

Author Closing Comment

by:Frank Freese
ID: 35110341
thank you....
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question