+ Reply to Thread
Results 1 to 6 of 6

Add water mark to all sheets

  1. #1
    Forum Contributor
    Join Date
    02-16-2012
    Location
    London, England
    MS-Off Ver
    Excel mac 2011
    Posts
    238

    Add water mark to all sheets

    Hi there,

    I am somewhat new to Power point, but I have a presentation from a previous month that needs updating by various people on sharepoint. What I wanted to do is add a watermark textbox (i.e. text box lilght coloured font set to say 36pt and rotate it to about 30 degrees) that just says please replace sheet, that way I can see who has updated.

    Now there are 42 sheets, is there a way I can select them all and add this text box without going through all of them individually. Please bear in mind that when this gets replaced with another sheet, this should no longer be there ie, I don't want it to be a permanent format.
    Kind regards

    Rob

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,859

    Re: Add water mark to all sheets

    Hi Rob,

    I know nothing about Powerpoint macros. The following Excel VBA code contains two slightly different macros that create PRELIMINARY watermarks on the Active Sheet. Numbers can be manipulated by trial and error for placement and size and color to suit your needs.

    If the code does what you want, post a sample workbook, and code can be created to put a suitable watermark on whatever sheets you want.

    Lewis

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-16-2012
    Location
    London, England
    MS-Off Ver
    Excel mac 2011
    Posts
    238

    Re: Add water mark to all sheets

    Hi, I have done this manually now, I was kind of hoping there was a quick trick like you can do with excel by shift and select the sheets you want to do repetative tasks with. With power point it seems you can't do anything useful like that.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,656

    Re: Add water mark to all sheets

    I know you resolved your problem manually but you can use this if it arises again.

    Manually add a shape to first slide, format and position as required. With the shape selected.
    ALT+F11 to open VBE
    CTRL+G to open immediate window.
    copy and paste the line of code and press enter.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    07-04-2014
    Location
    Australia
    MS-Off Ver
    ggkhhghjgg
    Posts
    6

    Re: Add water mark to all sheets

    I wanted to know how to do this as well. Like you, I manually added the water marks. I guess there's no shortcut to it.

  6. #6
    Registered User
    Join Date
    10-27-2014
    Location
    usa
    MS-Off Ver
    version 7
    Posts
    4

    Re: Add water mark to all sheets

    Quote Originally Posted by hectorconey12 View Post
    I wanted to know how to do this as well. Like you, I manually added the water marks. I guess there's no shortcut to it.
    yes, i took thing that there is no short cut becuase i tried this many time but i could not find anything and had to do manually itself

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Image as water mark
    By tqm1 in forum Excel General
    Replies: 2
    Last Post: 05-25-2007, 06:25 AM
  2. How to keep a high water mark
    By TerryM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-10-2006, 03:06 PM
  3. Water mark
    By m_ravindran in forum Excel General
    Replies: 1
    Last Post: 01-28-2006, 06:25 AM
  4. [SOLVED] How do I make a water mark on an excel spreadsheet?
    By Lelindar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-05-2005, 10:06 PM
  5. How To Remove Page 1 Water Mark?
    By travelersway in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-27-2005, 03:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1