Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 9th 09, 01:36 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 2
Default Can't remove check boxes

Couldn't find a post that addresses these two problems.

I copied a bunch of data from my Scottrade history and wound up with a line
of check boxes on the right side of a column of cost numbers. No matter what
I do I can't remove them. Can anyone tell me how to do this?

Also, I want to remove the hyperlinks that are part of a column of stock
symbols. I can remove them individually but what to do so to the whole
column. Any advice on how to do this?

  #2   Report Post  
Old March 9th 09, 02:12 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Can't remove check boxes

You'll want to show the Control toolbox toolbar.
In xl2003 menus:
View|toolbars|check control toolbox

In xl2007, this is on the developer tab (IIRC).

Then click on the design mode icon.

Then you can select the first control, then ctrl-click on subsequent.

If there are no controls that should be kept:
F5 (or ctrl-g or Edit|Goto)|Special
Objects

And then hit the delete key.

======
If you want to delete hyperlinks (the ones that come from Insert|Hyperlink):
you can select the range (all the cells if you want)
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then close this window and back to excel to check it out.




***TominFL*** wrote:

Couldn't find a post that addresses these two problems.

I copied a bunch of data from my Scottrade history and wound up with a line
of check boxes on the right side of a column of cost numbers. No matter what
I do I can't remove them. Can anyone tell me how to do this?

Also, I want to remove the hyperlinks that are part of a column of stock
symbols. I can remove them individually but what to do so to the whole
column. Any advice on how to do this?


--

Dave Peterson
  #3   Report Post  
Old March 9th 09, 03:12 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 2
Default Can't remove check boxes

As to the hyperlinks removal, that worked -- very neat. Thanks!

But concerning the stubborn check boxes, I did what you said as best I could
but no result. Probably didn't get your direction right - I'm a newbie. Could
I send you a file (virus safe) to show what I'm trying to get rid of?


"Dave Peterson" wrote:

You'll want to show the Control toolbox toolbar.
In xl2003 menus:
View|toolbars|check control toolbox

In xl2007, this is on the developer tab (IIRC).

Then click on the design mode icon.

Then you can select the first control, then ctrl-click on subsequent.

If there are no controls that should be kept:
F5 (or ctrl-g or Edit|Goto)|Special
Objects

And then hit the delete key.

======
If you want to delete hyperlinks (the ones that come from Insert|Hyperlink):
you can select the range (all the cells if you want)
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then close this window and back to excel to check it out.




***TominFL*** wrote:

Couldn't find a post that addresses these two problems.

I copied a bunch of data from my Scottrade history and wound up with a line
of check boxes on the right side of a column of cost numbers. No matter what
I do I can't remove them. Can anyone tell me how to do this?

Also, I want to remove the hyperlinks that are part of a column of stock
symbols. I can remove them individually but what to do so to the whole
column. Any advice on how to do this?


--

Dave Peterson

  #4   Report Post  
Old March 9th 09, 03:22 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Can't remove check boxes

No thanks.

What failed?

And what version of excel are you using?

***TominFL*** wrote:

As to the hyperlinks removal, that worked -- very neat. Thanks!

But concerning the stubborn check boxes, I did what you said as best I could
but no result. Probably didn't get your direction right - I'm a newbie. Could
I send you a file (virus safe) to show what I'm trying to get rid of?


"Dave Peterson" wrote:

You'll want to show the Control toolbox toolbar.
In xl2003 menus:
View|toolbars|check control toolbox

In xl2007, this is on the developer tab (IIRC).

Then click on the design mode icon.

Then you can select the first control, then ctrl-click on subsequent.

If there are no controls that should be kept:
F5 (or ctrl-g or Edit|Goto)|Special
Objects

And then hit the delete key.

======
If you want to delete hyperlinks (the ones that come from Insert|Hyperlink):
you can select the range (all the cells if you want)
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then close this window and back to excel to check it out.




***TominFL*** wrote:

Couldn't find a post that addresses these two problems.

I copied a bunch of data from my Scottrade history and wound up with a line
of check boxes on the right side of a column of cost numbers. No matter what
I do I can't remove them. Can anyone tell me how to do this?

Also, I want to remove the hyperlinks that are part of a column of stock
symbols. I can remove them individually but what to do so to the whole
column. Any advice on how to do this?


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Old March 10th 09, 04:28 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 857
Default Can't remove check boxes

Hi,

1. You can remove the hyperlinks by selecting an empty cell and choosing
Copy, highlighting all the hyperlinks and choosing Edit, Paste Special, Add.

2. Generally you can remove checkboxes by pressing F5, Special, Objects, OK.
And then pressing Del.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"***TominFL***" wrote:

Couldn't find a post that addresses these two problems.

I copied a bunch of data from my Scottrade history and wound up with a line
of check boxes on the right side of a column of cost numbers. No matter what
I do I can't remove them. Can anyone tell me how to do this?

Also, I want to remove the hyperlinks that are part of a column of stock
symbols. I can remove them individually but what to do so to the whole
column. Any advice on how to do this?



  #6   Report Post  
Old October 14th 13, 11:18 AM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2013
Posts: 1
Default

Quote:
Originally Posted by Dave Peterson View Post
You'll want to show the Control toolbox toolbar.
In xl2003 menus:
View|toolbars|check control toolbox

In xl2007, this is on the developer tab (IIRC).

Then click on the design mode icon.

Then you can select the first control, then ctrl-click on subsequent.

If there are no controls that should be kept:
F5 (or ctrl-g or Edit|Goto)|Special
Objects

And then hit the delete key.

======
If you want to delete hyperlinks (the ones that come from Insert|Hyperlink):
you can select the range (all the cells if you want)
Hit alt-f11 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window
type this and hit enter:
selection.hyperlinks.delete

Then close this window and back to excel to check it out.




***TominFL*** wrote:

Couldn't find a post that addresses these two problems.

I copied a bunch of data from my Scottrade history and wound up with a line
of check boxes on the right side of a column of cost numbers. No matter what
I do I can't remove them. Can anyone tell me how to do this?

Also, I want to remove the hyperlinks that are part of a column of stock
symbols. I can remove them individually but what to do so to the whole
column. Any advice on how to do this?


--

Dave Peterson
i tried your trick and was able to remove all check boxes in less then 15 seconds.


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
How do I increase the size of check in check boxes Adams, Les Excel Discussion (Misc queries) 0 September 19th 06 02:35 PM
Enable check box in protected sheet + group check boxes Dexxterr Excel Discussion (Misc queries) 4 August 2nd 06 12:00 PM
How do I remove (form) check-boxes from multiple excel fields? ATSANAC Excel Discussion (Misc queries) 2 May 11th 06 06:48 PM
How do i create a value for check boxes or option boxes Tim wr Excel Discussion (Misc queries) 1 February 9th 06 11:29 PM
How do I remove unwanted check boxes which tagged along from anoth tim Excel Discussion (Misc queries) 1 July 21st 05 03:13 AM


All times are GMT +1. The time now is 11:38 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017