I didn't know the "F" keys were programmed at all?!? Hmmmm
--
Ferret Mom


"Dave Peterson" wrote:

I don't know.

Heck, I don't know if all the versions of excel have the F keys the same. I
don't recall any difference between xl95 through xl2003. I haven't used xl2007
very much, but I haven't noticed any differences with that version, either.

PK wrote:

Are all versions of windows set up with the same F-Keys?
--
Ferret Mom

"Dave Peterson" wrote:

Select the range to remove the hyperlinks from (all the cells on the worksheet
if you want)

Then hit alt-f11 to get to the VBE
hit ctrl-g
type this:
selection.hyperlinks.delete
and hit enter

Then back to excel to check.

PK wrote:

Wow, that works great and is easy. Do you have an easy method to remove all
hyperlinks too?
--
Ferret Mom

"Alan" wrote:

Edit Goto Special Check 'Objects' OK will highlight them all, hit
Delete.
Note that this will delete all objects on the sheet, not just the
checkboxes,
Regards,
Alan.
"PK" wrote in message
...
How do I go about deleting check boxes (400 + lines with 4 on each line)
copies from internet to an excel page, in one fell swoop? Or can't I.
--
Ferret Mom



--

Dave Peterson


--

Dave Peterson