I Want to hide stuff

Joined
Feb 16, 2002
Messages
38
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!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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
 
Upvote 0
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
 
Upvote 0
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
:)
 
Upvote 0
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")
 
Upvote 0

Forum statistics

Threads
1,213,484
Messages
6,113,927
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top