#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Sheet Tabs

I am building an application that only allows one sheet to be visible at a
time. This is done through macros assigned to buttons on the various sheets.
I expect that the application will get translated including some double byte
languages. I would like to avoid having to translate the sheet tabs. Is there
a way to change the color of the font on the tabs so that the the titles are
not visible, and therefore don't need to be translated? I know you can change
the color of the tabs, but it seems that the font color changes based on the
color to remain visible.

Thanks!
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default Sheet Tabs

I don't believe access to the sheet tab font color is available.
However, you do have some options...
1. Use consecutive numbers...1, 2, 3. Usually not necessary to translate.
2. Use consecutive symbols of some sort... |, ||, |||
3. Use spaces... That will give you up to 31 different names and nothing
will show on the tab. The tabs will be different widths however.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"RBeau"
wrote in message
I am building an application that only allows one sheet to be visible at a
time. This is done through macros assigned to buttons on the various sheets.
I expect that the application will get translated including some double byte
languages. I would like to avoid having to translate the sheet tabs. Is there
a way to change the color of the font on the tabs so that the the titles are
not visible, and therefore don't need to be translated? I know you can change
the color of the tabs, but it seems that the font color changes based on the
color to remain visible.

Thanks!
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,290
Default Sheet Tabs

http://www.cpearson.com/excel/newposte.htm
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Could this be possible? shail Excel Worksheet Functions 9 September 13th 06 12:35 PM
My sheet tabs disappeared with entered data. Can it be restored? Irene V in NJ Excel Discussion (Misc queries) 8 September 12th 06 05:43 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Why do sheet tabs keep disappearing? Box in Tools is checked. Arlie Excel Discussion (Misc queries) 1 January 5th 06 01:18 PM
Does excel recognise names rather than cells? Sue Excel Worksheet Functions 9 May 22nd 05 04:51 AM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"