Hiding Row numbers and Column Letters?

[Ethos]

Hi, Could anyone tell me how I can Hide the Row numbers and Column Letters within a worksheet.


Regards,

Ethos

 

[boblarson]

Are you talking manually or programmatically? Manually it is going to Tools > Options > View and unchecking "Show Column & Row Headers."

 

[boblarson]

Programmatically it is:

ActiveWindow.DisplayHeadings = False

 

[Ethos]

Thank you,

I just wondered how "they" managed to format individual spreadsheets in plush financial workbooks in accounting.

regards,

Ethos.

 

[unmarkedhelicopter]

You consider that Plush ?
That is usually one of the first things I get rid of when someone sends me a workbook.
Another "pet hate" is when they format cells white to get rid of grid lines instead of just turning them off.

 

[shades]

No, merged cells are the worst.
________
WEBSITE HOST

 

[clive2002]

i like merged cells when used correctly, its empty spacer columns that really get me mad.

 

[unmarkedhelicopter]

Oooh Oooh Oooh,
I wanna change my vote, I'm going with the following list !

1. Merged Cells (thanks Rich !, that's so ... irritating, what's wrong with centre across selection ?)
2. Cells formatted White
3. Anything to do with 'Page Break Preview'
4. Removal of Row & Column Headers
5. People who modify a sheet 'standard colours' without a GOOD reason
6. People who think sheet protect and workbook protect, actually protect something
...
101. (cos it's okay in a well thought out application) Sheet Tab Removal (I do it 'sometimes')

I don't have a problem with spacer columns or rows unless the sheet is used as a datatable (but other sheets that access that can do it). Why do you have a problem with them clive2002 ?

Anybody else have a 'pet hate' list addition ? / re-order ?