Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 spreadsheet - gridlines won't print when opened in 2007 | Excel Discussion (Misc queries) | |||
Excel File Protection 2003 vs. 2007 | Excel Discussion (Misc queries) | |||
2007 vs 2003 - work protection | Excel Discussion (Misc queries) | |||
charts missing when 2003 file opened in 2007 | Charts and Charting in Excel | |||
data missing in charts original file 97-2003 opened 2007 and then. | Charts and Charting in Excel |