I Want to hide stuff
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: I Want to hide stuff

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a macro which automatically sends a user when activated to a website however I want to get rid of the website URL which is in my workbook please help!

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    not get rid of it but hide it from the workbood

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    do you mean hide the macro button which activates it, or hide the macro itself ?

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    no to hide the URL

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-28 12:47, Arash_The_A_Level_Student wrote:
    no to hide the URL
    1) hide the row it sits in
    2) hide the column it sits in
    2a) hide the sheet it resides within
    3) format the hyperlink from underlined blue to non-underlined font=white

    would any of those help ?

    Chris



    [ This Message was edited by: Chris Davison on 2002-02-28 12:58 ]

  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yeah I can't hide the row or the cell that it's in because it is merged and I've got the colour of the hyperlink white now

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-28 12:57, Arash_The_A_Level_Student wrote:
    yeah I can't hide the row or the cell that it's in because it is merged and I've got the colour of the hyperlink white now
    Arash,

    are we close then ? we have the hyperlink in white font, presumably the same colour as the sheet background.... is this not now "hidden" ?


    edit - you're going to say missing gridlines aren't you ?!

    [ This Message was edited by: Chris Davison on 2002-02-28 13:03 ]

  8. #8
    New Member
    Join Date
    Feb 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    yeah but I need it to be hidden, incase the user does not click on it accidently

  9. #9
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Arash,

    there's probably a much better way, starting from scratch

    however, to continue this avenue ; try this trick :

    goto :

    view
    toolbars
    customize
    commands
    tools
    scrolldown till you see the camera icon
    click on it and drag it into your toolbar
    close this box

    now :

    highlight an area of cells on a totally blank sheet and click on the new camera
    icon to take a picture

    then click on the same area to size that picture and drag it down and right - this will size a picture of blank cells underneath your hidden hyperlink

    right click on it to position it over your hidden hyperlink. Right click and choose :

    format picture
    colour and lines
    colour = no fill
    line colour = no line

    then hide the totally blank sheet you took your snapshot from.

    this should basically plonk a picture of blank cells over the top of your hyperlink preventing anyone from clicking on it.

    Like I said, this solves this avenue, but I'm sure there's a better way starting from scratch.

    (Have a play around with that camera utility, I use it a lot, it's very useful)

    hope this helps mate
    Chris

  10. #10
    New Member
    Join Date
    Feb 2002
    Location
    St. Paul, Minnesota, USA
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Chris - the camera utility is indeed interesting. I'd never looked at it before. I found that the Excel "help" system doesn't seem to know that the tool exists, however! (try going to the help index and typing "camera")

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com