Tabs on the Top?

[golf4]

Greetings to everyone -

Don't know if this is possible, but thought I'd check. Is there a way to change a spreadsheet from having the tabs at the botom of the page and place them at the top? Thanks

 

[Juan Pablo González]

Mhmm, no, not that I know of.

 

[golf4]

Thanks for the quick response.

 

[stevebausch]

You could fake it.

The code would be kept in a module, and each sheet's Worksheet_selectionChange would call it.
You would dedicate the top row of each sheet to this scheme. If you can, have the cell widths approach a sheet tab's width. Set the cell colors to mimic a sheet tab. A clumsy attempt to separate the tabs can be done with Borders.

The code? Oh yes, the code. It would check to see if a specific cell was selected, and .Activate the respective sheet.

If you really get ambitious, perhaps images of sheet tabs could be put in the cells.

Don't know who is driving this task. Hopefully they will appreciate the effort you put into this.


If you do this, the devil is in the details:
Managing the font's Bold/Normal attribute.
Managing the background color; selected tab is white background, the other tabs are what, 25% Gray?
This message was edited by stevebausch on 2002-10-12 20:32

 

[PaddyD]

On 2002-10-11 23:26, golf4 wrote:
Greetings to everyone -

Don't know if this is possible, but thought I'd check. Is there a way to change a spreadsheet from having the tabs at the botom of the page and place them at the top? Thanks

Keep everything about the excel environment exactly as is, but stick the remaining office furniture to the ceiling.

Paddy