2003 checkboxes and sheet protection opened in 2007
 

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

2003 checkboxes and sheet protection opened in 2007
 

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:
W: www.spreadsheetsolutions.nl
--

"seattle josh" wrote in message
...
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

2003 checkboxes and sheet protection opened in 2007
 

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"
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 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:
W:www.spreadsheetsolutions.nl
*--

"seattle josh" wrote in message

...

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