Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Is there a way to delete a predefined footer in Excel ?

There are a number of predefined footers in Excel, ie: page 1 of... The
footer I am specifically wanting to delete is: Confidential. There must be
a way, but I haven't found it yet. Please advise.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Is there a way to delete a predefined footer in Excel ?

No way to delete the pre-defined "Confidential".

Just curious......why would you want to delete that particular footer?


Gord Dibben MS Excel MVP

On Mon, 10 Sep 2007 12:46:05 -0700, LisaC
wrote:

There are a number of predefined footers in Excel, ie: page 1 of... The
footer I am specifically wanting to delete is: Confidential. There must be
a way, but I haven't found it yet. Please advise.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 227
Default Is there a way to delete a predefined footer in Excel ?

I don't think it's possible. Watch someone else prove me wrong (I
hope so). :)

Mark Lincoln

On Sep 10, 3:46 pm, LisaC wrote:
There are a number of predefined footers in Excel, ie: page 1 of... The
footer I am specifically wanting to delete is: Confidential. There must be
a way, but I haven't found it yet. Please advise.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Is there a way to delete a predefined footer in Excel ?

In the military, putting confidential in the footer section means something
other than your typical confidential. One of our users used this standard
footer and it's causing a security inquery. So, simply advising people not
to use it doesn't alway's work.

"Gord Dibben" wrote:

No way to delete the pre-defined "Confidential".

Just curious......why would you want to delete that particular footer?


Gord Dibben MS Excel MVP

On Mon, 10 Sep 2007 12:46:05 -0700, LisaC
wrote:

There are a number of predefined footers in Excel, ie: page 1 of... The
footer I am specifically wanting to delete is: Confidential. There must be
a way, but I haven't found it yet. Please advise.



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Is there a way to delete a predefined footer in Excel ?

Thank you for the feedback.

Curiosity problem now solved.

Using VBA code you may be able to prevent printing if the "Confidential" shows
up in a footer or header.


Gord

On Mon, 10 Sep 2007 13:28:02 -0700, LisaC
wrote:

In the military, putting confidential in the footer section means something
other than your typical confidential. One of our users used this standard
footer and it's causing a security inquery. So, simply advising people not
to use it doesn't alway's work.

"Gord Dibben" wrote:

No way to delete the pre-defined "Confidential".

Just curious......why would you want to delete that particular footer?


Gord Dibben MS Excel MVP

On Mon, 10 Sep 2007 12:46:05 -0700, LisaC
wrote:

There are a number of predefined footers in Excel, ie: page 1 of... The
footer I am specifically wanting to delete is: Confidential. There must be
a way, but I haven't found it yet. Please advise.






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Is there a way to delete a predefined footer in Excel ?

Thank you - that is something I hadn't thought about.

"Gord Dibben" wrote:

Thank you for the feedback.

Curiosity problem now solved.

Using VBA code you may be able to prevent printing if the "Confidential" shows
up in a footer or header.


Gord

On Mon, 10 Sep 2007 13:28:02 -0700, LisaC
wrote:

In the military, putting confidential in the footer section means something
other than your typical confidential. One of our users used this standard
footer and it's causing a security inquery. So, simply advising people not
to use it doesn't alway's work.

"Gord Dibben" wrote:

No way to delete the pre-defined "Confidential".

Just curious......why would you want to delete that particular footer?


Gord Dibben MS Excel MVP

On Mon, 10 Sep 2007 12:46:05 -0700, LisaC
wrote:

There are a number of predefined footers in Excel, ie: page 1 of... The
footer I am specifically wanting to delete is: Confidential. There must be
a way, but I haven't found it yet. Please advise.




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
Calling a Userform from a Predefined Variable [email protected] Excel Worksheet Functions 0 April 21st 07 03:44 PM
How to delete footer & header history in Excel? TNGIBBY Excel Worksheet Functions 1 February 8th 06 06:47 AM
How do I delete the drop down list of header / footer options in e Progress Finance Excel Discussion (Misc queries) 1 December 1st 05 06:49 PM
how to delete unused footer dialogs in excell Jaycee Excel Worksheet Functions 0 September 29th 05 08:07 PM
how to delete an auto footer Dool Excel Discussion (Misc queries) 4 June 10th 05 01:19 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"