I Want to hide stuff

Arash_The_A_Level_Student · Feb 28th, 2002, 01:06 PM

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!

Arash_The_A_Level_Student · Feb 28th, 2002, 01:07 PM

not get rid of it but hide it from the workbood

Chris Davison · Feb 28th, 2002, 01:46 PM

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

Arash_The_A_Level_Student · Feb 28th, 2002, 01:47 PM

no to hide the URL

Chris Davison · Feb 28th, 2002, 01:55 PM

Quote:

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 ]

Arash_The_A_Level_Student · Feb 28th, 2002, 01:57 PM

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

Chris Davison · Feb 28th, 2002, 02:01 PM

Quote:

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 ]

Arash_The_A_Level_Student · Feb 28th, 2002, 02:04 PM

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

Chris Davison · Feb 28th, 2002, 02:15 PM

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

Dennis59 · Mar 1st, 2002, 06:47 AM

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")

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 01:06 PM	#1
Arash_The_A_Level_Student New Member Join Date: Feb 2002 Posts: 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!

Feb 28th, 2002, 01:07 PM	#2
Arash_The_A_Level_Student New Member Join Date: Feb 2002 Posts: 38	not get rid of it but hide it from the workbood

Feb 28th, 2002, 01:46 PM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	do you mean hide the macro button which activates it, or hide the macro itself ?

Feb 28th, 2002, 01:47 PM	#4
Arash_The_A_Level_Student New Member Join Date: Feb 2002 Posts: 38	no to hide the URL

Feb 28th, 2002, 01:57 PM	#6
Arash_The_A_Level_Student New Member Join Date: Feb 2002 Posts: 38	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

Feb 28th, 2002, 02:04 PM	#8
Arash_The_A_Level_Student New Member Join Date: Feb 2002 Posts: 38	yeah but I need it to be hidden, incase the user does not click on it accidently

Feb 28th, 2002, 02:15 PM	#9
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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

Mar 1st, 2002, 06:47 AM	#10
Dennis59 New Member Join Date: Feb 2002 Location: St. Paul, Minnesota, USA Posts: 8	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")