View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Hotbird[_2_] Hotbird[_2_] is offline
external usenet poster
 
Posts: 19
Default Tools/Options/ Row & column headers

Yes, it was exactly what I was looking for, Jerry, many thanks.

TY also to the other poster who suggested that the Macro recorder was an
easy way to find the correct code. I had spent quite long enough on a
fruitless search through F1 Help, and must admit I forgot the obvious!!!

"JerryG" wrote in message
...

ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayHeadings = True

Hope this was what you were looking for.


JerryG :)