ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Margin Lines (https://www.excelbanter.com/excel-worksheet-functions/160270-margin-lines.html)

Christopher Leigh Stout

Margin Lines
 
How do I turn off the page margins so that they do not show in normal view?

Gord Dibben

Margin Lines
 
ToolsOptionsView.

Uncheck "PageBreaks"

Note: this is not a workbook or global setting.................active window
only.

Switch sheets and you have to do it again.

The only way to have it disabled for all sheets would be to run Workbook_Open
code or sheet_activate code.



Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 18:23:01 -0700, Christopher Leigh Stout
wrote:

How do I turn off the page margins so that they do not show in normal view?



Christopher Leigh Stout

Margin Lines
 
I am using the new 2007 Excel. I do not see tools.

"Gord Dibben" wrote:

ToolsOptionsView.

Uncheck "PageBreaks"

Note: this is not a workbook or global setting.................active window
only.

Switch sheets and you have to do it again.

The only way to have it disabled for all sheets would be to run Workbook_Open
code or sheet_activate code.



Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 18:23:01 -0700, Christopher Leigh Stout
wrote:

How do I turn off the page margins so that they do not show in normal view?




Gord Dibben

Margin Lines
 
Sorry.

I don't use Excel 2007 yet so have no idea where Tools is located.

Someone using 2007 will be along shortly to assist.

In the meantime browse through Ron de Bruin's Excel 2007 Commands site and see
if you can find it.

http://www.rondebruin.nl/0307commands.htm


Gord

On Sun, 30 Sep 2007 20:04:00 -0700, Christopher Leigh Stout
wrote:

I am using the new 2007 Excel. I do not see tools.

"Gord Dibben" wrote:

ToolsOptionsView.

Uncheck "PageBreaks"

Note: this is not a workbook or global setting.................active window
only.

Switch sheets and you have to do it again.

The only way to have it disabled for all sheets would be to run Workbook_Open
code or sheet_activate code.



Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 18:23:01 -0700, Christopher Leigh Stout
wrote:

How do I turn off the page margins so that they do not show in normal view?





Peo Sjoblom

Margin Lines
 
http://office.microsoft.com/en-us/ex...CH100798591033


--

Regards,

Peo Sjoblom





"Christopher Leigh Stout"
wrote in message ...
I am using the new 2007 Excel. I do not see tools.

"Gord Dibben" wrote:

ToolsOptionsView.

Uncheck "PageBreaks"

Note: this is not a workbook or global setting.................active
window
only.

Switch sheets and you have to do it again.

The only way to have it disabled for all sheets would be to run
Workbook_Open
code or sheet_activate code.



Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 18:23:01 -0700, Christopher Leigh Stout
wrote:

How do I turn off the page margins so that they do not show in normal
view?






Christopher Leigh Stout

Margin Lines
 
Neither of these work, still lost. Already did the first one, no idea in the
second one.

"Peo Sjoblom" wrote:

http://office.microsoft.com/en-us/ex...CH100798591033


--

Regards,

Peo Sjoblom





"Christopher Leigh Stout"
wrote in message ...
I am using the new 2007 Excel. I do not see tools.

"Gord Dibben" wrote:

ToolsOptionsView.

Uncheck "PageBreaks"

Note: this is not a workbook or global setting.................active
window
only.

Switch sheets and you have to do it again.

The only way to have it disabled for all sheets would be to run
Workbook_Open
code or sheet_activate code.



Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 18:23:01 -0700, Christopher Leigh Stout
wrote:

How do I turn off the page margins so that they do not show in normal
view?







All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com