Showing related tags and posts accross the entire site.
-
Hi all
It is not possible to add to or remove controls from built-in groups in the Ribbon. For example, the
Format Painter button from the Home tab’s Clipboard group cannot be removed from this group.
But there is a way around this restriction.
We can hide a built-in group and then duplicate it...
-
Joel Spolsky says don’t:
Instead, leave the menu item enabled. If there’s some reason you can’t complete the action, the menu item can display a message telling the user why.
I thought it was pretty common knowledge that users don’t read message boxes. Anyway, I’m squarely...
-
Hi all,
For a project I needed a quick way to display the content of an array to the user. I didn’t want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like: Description
Before
After Cell Errors
100
10 Corrupt Names...
-
Hi, I want to share an Excel 2003 spreadsheet with 4,500 users. The users open the spreadsheet, enter their user id and get some information. I expect that this will be a one-time operation and lasts a few minutes per user. My plan is to save the spreadsheet as a template and share on a network drive...
-
One topic I have not seen much discussion on is how to transform business logic into an automated user-maintainable workbook. I've had to deal with similar situations in various settings, so I am sure it is a common problem, so I'm curious to see what other approaches exist. Two examples: A data...
-
This is a great site. It reminds me of going from grade 8 to highschool. Grade 8, I was one of the big kids. The following year, I was one of the ??? At work, I'm the big grade 8'er. Here, just a kid. Does anyone bother with using Excel styles? I don't ever read anything about them, so either...
-
Hi all
I create a small Excel add-in to copy a customized QAT from one workbook to another.
http://www.rondebruin.nl/imageqat.htm#QAT
Because it not use very common code I like to hear from you if you have problems
or if there are there better ways to do it ?
I hope a few of you can test it for me....
-
Hi all
I add a new page to my site with examples to change a button image
of a button in the QAT for all workbooks or for one workbook.
Making a QAT Add-in of the one workbook example seems a good way on
this moment if you want to change the buttons images of your QAT.
http://www.rondebruin.nl/imageqat...