I made an excel file in 2003 and it has lots of checkboxes made from
the control toolbox.

With the sheet protected these work in my 2003 excel but when my
coworker with excel 2007 it doesn't. They worked for her before I
protected the sheet. I'm not a 2007 user, so Is there something it
does differently in this regard to stop the checkboxes from working
while the sheet is protected and what to do about it?

And the kind of sheet protection I'm using is what I got from this
group. I have to use it because normal sheet protection disables too
much. Can you tell me if this has a problem in 2007?

With Worksheets("SheetX")
.Protect Password:="password", userinterfaceonly:=True
.EnableOutlining = True
End With

Josh;

For a starter:

Where did you get this code from.
As you can see, it is inconsequent in the way that it is typed.

EnableOutlining seems the "VBA way" in that the 2 words forming this text
begin with an UpperCase.
userinterfaceonly does not seem to be right, as it should be written down as
UserInterfaceOnly.

If code, or keywords are genuine VBA code, or keywords, text will
automatically adjusted to the proper spelling, with Uppercases if neccesary.

So, if that isn't the case, you might conclude that this keyword is not
recognised as actual VBA code !

I'll try to test the code tomorrow.
It's bedtime over here now.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands (Those who live some 18 feet below sea level)
--
E: (E-Mail Removed)
W: www.spreadsheetsolutions.nl
--

"seattle josh" <(E-Mail Removed)> wrote in message
news:c6018b9b-d3da-46a7-be3a-(E-Mail Removed)...
>I made an excel file in 2003 and it has lots of checkboxes made from
> the control toolbox.
>
> With the sheet protected these work in my 2003 excel but when my
> coworker with excel 2007 it doesn't. They worked for her before I
> protected the sheet. I'm not a 2007 user, so Is there something it
> does differently in this regard to stop the checkboxes from working
> while the sheet is protected and what to do about it?
>
> And the kind of sheet protection I'm using is what I got from this
> group. I have to use it because normal sheet protection disables too
> much. Can you tell me if this has a problem in 2007?
>
> With Worksheets("SheetX")
> .Protect Password:="password", userinterfaceonly:=True
> .EnableOutlining = True
> End With

I get agree with the point, but lots of users have it as all lower
case. Take a look here, http://tinyurl.com/userinterfaceonly. And the
code runs on 2003, so we know it works, but I understand you
observation.

Anyway, I just tested it myself on 2007 and it ran fine. My coworker
just didn't have her macros turned on because she didn't that itty-
bitty macro message in the upper left. <lol> She was used to the big
mondo-warning in 2003.



On Feb 18, 2:23*pm, "Spreadsheet Solutions" <m...@rosenkrantz.nl>
wrote:
> Josh;
>
> For a starter:
>
> Where did you get this code from.
> As you can see, it is inconsequent in the way that it is typed.
>
> EnableOutlining seems the "VBA way" in that the 2 words forming this text
> begin with an UpperCase.
> userinterfaceonly does not seem to be right, as it should be written downas
> UserInterfaceOnly.
>
> If code, or keywords are genuine VBA code, or keywords, text will
> automatically adjusted to the proper spelling, with Uppercases if neccesary.
>
> So, if that isn't the case, you might conclude that this keyword is not
> recognised as actual VBA code !
>
> I'll try to test the code tomorrow.
> It's bedtime over here now.
>
> --
> Regards;
> Mark Rosenkrantz
> --
> Spreadsheet Solutions
> Uithoorn
> Netherlands (Those who live some 18 feet below sea level)
> --
> E: *m...@rosenkrantz.nl
> W:www.spreadsheetsolutions.nl
> *--
>
> "seattle josh" <hppavillio...@yahoo.com> wrote in message
>
> news:c6018b9b-d3da-46a7-be3a-(E-Mail Removed)...
>
> >I made an excel file in 2003 and it has lots of checkboxes made from
> > the control toolbox.
>
> > With the sheet protected these work in my 2003 excel but when my
> > coworker with excel 2007 it doesn't. They worked for her before I
> > protected the sheet. I'm not a 2007 user, so Is there something it
> > does differently in this regard to stop the checkboxes from working
> > while the sheet is protected and what to do about it?
>
> > And the kind of sheet protection I'm using is what I got from this
> > group. I have to use it because normal sheet protection disables too
> > much. Can you tell me if this has a problem in 2007?
>
> > With Worksheets("SheetX")
> > * .Protect Password:="password", userinterfaceonly:=True
> > * .EnableOutlining = True
> > End With