On Tue, 29 Mar 2011 20:27:52 -0700, Gord Dibben
wrote:
Be careful with how much you customize your Toolbars.
*.xlb files are easily corrupted and cause problems with Excel.
Thanks but I've been using them for many, many years now ... in fact,
I can't even remember how long ago it was when I first started.
Certainly can't remember in the last 20 years when I didn't use them.
It's just that in the old days, my xlbs, etc., and backups I carried
around on floppies that I carried in a clear plastic floppy box case
that would hold about 10 floppies <g. Sure is a far cry from the
small 16gig flash drive I carry around now. And I say small because I
could use one that is larger it's just that present economy and salary
doesn't allow it in the budget <g. Yet in all this time of using
them, doing contract work in last 20 years, never had a problem even
though loaded them up in each new job and used several different host
computers in any given year. They're great.
Make sure you always have backups of you *.xlb files.
I do, thanks.
Best to create Toolbars and Menus "on the fly" then delete them when closing.
I have floating toolbars on many of my indivdual sheets, but I like
the main look of my Excel with the xlb as it stands with my own
standard 5 extra toolbars. It's pretty kewl. Again, the faceIDs have
much of the same limitations as the QATs, you can' customize the icons
and you're stuck with the selection. However, I have made them work
and they are handy esp. for those workbooks that require a new sheet
be created from a master periodically. In the beginning I used
buttons that I'd place on the sheet. These worksheet buttons would in
effect be replicated on each new sheet and would make the workbook's
size mount up pretty quickly <g. So in those cases, I've used these
floating toolbars instead for some time now even though it's a
relatively new skill for me. I've used these
vb toolbars for about
the last 5 or 6 years or so only. But my xlbs provide my main
interface and which has made the odd co-worker comment that my Excel
interface looks like a darned cockpit or something, it looks so
complicated according to them. That always makes me laugh. It's not,
it's made my life so incredibly simple, something M$ again didn't
consider when they decided to "improve" <hah. Anyway, I'm lucky. I
still get contracts with the older versions, thank goodness. And
since it's government, that will likely continue for some time.
Because, personally, if M$ doesn't smarten up, I will continue stopped
at 2003 since I refuse to upgrade to newer versions. Bad enough I'm
forced to use them at work. There are alternatives out there to
consider in lieu of, so hopefully M$ keeps that in mind.
:oD
See how at Debra's site.
http://www.contextures.on.ca/xlToolbar02.html
Also look at John Walkenbach's MENUMAKR.xls
http://spreadsheetpage.com/index.php/file/menu_maker/
Gord Dibben MS Excel MVP
On Tue, 29 Mar 2011 21:29:11 -0500, StargateFan
wrote:
The neat things about this is that I'm lucky in that we're still on
Excel 2003 at my current contract and I can add a button to my lovely,
lovely Excel11.xlb with this print code once I figure out if it works
for me and then can add it to the rest of my print buttons.