Excel & Customise Toolbar buttons

  Zak 12:59 07 Feb 2009

Please can anyone explain the following:

View - Toolbars - Customise

Select Commands Tab and Format left hand pane

In right pane there is a "Show or Hide" command with abc A icon.

First I cannot find out what it does and

Secondly I am unable to drag it to a toolbar, existing or new.

VoG™ if you are available please help.

Above started as a quest because I am looking for a toolbar button to Show or Hide worksheets. I have solved by dragging from menu. Also ASAP utilities provide a solution. However at work the Excel as everything else is very much restricted and we are not permitted to add in any programs or utilities.

  Zak 13:01 07 Feb 2009

Excel 2000 and 2003

  Chris the Ancient 14:52 07 Feb 2009

and 2003!

Some others in that vicinity are in a similar vein. And I don't know the answer either!

  VoG II 17:39 07 Feb 2009

Sorry I only have access to XL 2007 until Monday.

  Zak 18:02 07 Feb 2009

Thanks for responding.

  daba 01:12 08 Feb 2009

Have you clicked on the "Description" button for the Selected Command....

It says ----

Show Phonetic Field
Show and Hide Furigana

Whatever that means.

Anyway, try searching Help for "Furigana" as I did, there's tons of stuff in there, and it's all about the phonetic (Furigana) characters in the Japanese version of Excel.

Way over my head, and obviously not what you are looking for.

I've looked at the option of a Custom Toolbar, with a view to putting some command buttons on it to show/hide sheets, and there doesn't seem to be those command options.

I think you will have to use vba code to achieve this. Not my strong point, and I'm sure someone will point you in the right direction.

  Zak 10:53 08 Feb 2009

Excel 2003 does not have a description button, but now that you mention it Excel 2000 at work does and Furigana was mentioned.

  VoG II 11:30 08 Feb 2009

You could add a smiley face like this click here

The code would be

Sub ToggleSheet()
Sheets("Sheet1").Visible = Not Sheets("Sheet1").Visible
End Sub

  Zak 16:09 09 Feb 2009

I'll give this a try.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone