Help Request: Protection

  • Thread starter Thread starter Monte Comeau
  • Start date Start date
M

Monte Comeau

Hi All...

I have a completed worksheet that will be used for scoring team scramble
type golf tournys.

It will be used by many different users so I would like to protect all but
the cells required for score entry.

I have done this, and not allowed them to select any other cell as well.

My problem is that I have a menu using Autoshapes (square buttons) with
hyperlinks assigned to them to them to allow users to navigate around the
sheet as it is quite large. When the sheet is protected these menu
buttons do not work. Any ideas on how to fix this problem?

many thanks in advance

if you want to view this sheet I have it at http://www.salmo.net/nineman.htm

Monte
 
As a follow up to this problem.

I am unable to use the SORT function while the sheet is protected as
well...is this just the way it is or can I have the sheet protected and
still have functionality?
 
If you are using Excel 2002 or 2003, you should be able to let people select Sort, edit Objects, etc. If you are using 2000 or earlier, I'm not sure if you can. And, if you can do it, you'll likely need VBA code. I can't help with that--sorry

tj
 
Tried that with no luck.

I have a macro set up to sort and it is assigned to a Autoshape...will not
work when sheet is protected.


tjtjjtjt said:
If you are using Excel 2002 or 2003, you should be able to let people
Click to expand...
select Sort, edit Objects, etc. If you are using 2000 or earlier, I'm not
sure if you can. And, if you can do it, you'll likely need VBA code. I can't
help with that--sorry.
 
After playing around with it a bit it seems like it is the hyperlinks that
do not work when the sheet is protected.

However, I have a hyperlink assigned to an autoshape that goes to another
sheet...it works fine, it's just the hyperlinks that go to specific cell
references within the same sheet that do not work when protection is on...
Any ideas...
 
Back
Top