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

Mr. Pearson,

Is there a way that I can default my rowliner so that when it starts, the
column and row lines do not appear? I just want the cell highlighted.

If you can help with this, I will certainly appreciate it.

Thanks,
G. Porter
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default RowLiner

go to toolsoptionsview tab and uncheck gridlines
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"PappyPorter" wrote:

Mr. Pearson,

Is there a way that I can default my rowliner so that when it starts, the
column and row lines do not appear? I just want the cell highlighted.

If you can help with this, I will certainly appreciate it.

Thanks,
G. Porter

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default RowLiner

With the Rowliner Add-in loaded, ViewRowLiner.

In the Row and Column options check "None".

Those settings will stick until you change them.


Gord Dibben MS Excel MVP

On Fri, 9 Mar 2007 14:32:02 -0800, john wrote:

Mr. Pearson,

Is there a way that I can default my rowliner so that when it starts, the
column and row lines do not appear? I just want the cell highlighted.

If you can help with this, I will certainly appreciate it.

Thanks,
G. Porter


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default RowLiner

I had already tried this. It works for the workbook where I performed the
action. However, when I open a different workbook, the column lines are
there. I would like to set the add-in so that it defaults to no row or
column lines regardless of which workbook I open.

I noticed in the registry that there are RowLiner options but am unsure
whether changins any of these options will reset the default.

Any help here?

Gord Dibben <gorddibbATshawDOTca wrote in
:

With the Rowliner Add-in loaded, ViewRowLiner.

In the Row and Column options check "None".

Those settings will stick until you change them.


Gord Dibben MS Excel MVP

On Fri, 9 Mar 2007 14:32:02 -0800, john
wrote:


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7,247
Default RowLiner

Send me an email at with your specific needs, what
happens that shouldn't happen, or what doesn't happen that should. Be
specific -- details count. Maybe its time to update the program.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Jonsey" wrote in message
.130...
I had already tried this. It works for the workbook where I performed the
action. However, when I open a different workbook, the column lines are
there. I would like to set the add-in so that it defaults to no row or
column lines regardless of which workbook I open.

I noticed in the registry that there are RowLiner options but am unsure
whether changins any of these options will reset the default.

Any help here?

Gord Dibben <gorddibbATshawDOTca wrote in
:

With the Rowliner Add-in loaded, ViewRowLiner.

In the Row and Column options check "None".

Those settings will stick until you change them.


Gord Dibben MS Excel MVP

On Fri, 9 Mar 2007 14:32:02 -0800, john
wrote:






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default RowLiner

Mr. Pearson,

I fixed this with a registry entry that works just fine for my situation.

"Chip Pearson" wrote in news:#O76wbrYHHA.4552
@TK2MSFTNGP05.phx.gbl:

Send me an email at with your specific needs, what
happens that shouldn't happen, or what doesn't happen that should. Be
specific -- details count. Maybe its time to update the program.


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
Macro to turn on/off rowliner? Ryk Excel Discussion (Misc queries) 6 October 3rd 06 08:08 AM
Rowliner woes Kim K Excel Discussion (Misc queries) 2 August 4th 06 03:20 PM


All times are GMT +1. The time now is 02:18 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"