Serializer and its draconian restrictions - comments sought

If you would believe the help and MS talk then the serializer will solve the
VB6 problem of making those numerous calls to SaveSetting and GetSetting to
save and retrieve the values of user defined settings often found in
Tools->Options, etc.

Although I have now twice implemented the serializer in separate C#
programs, its rules for usage are so draconian that I had to significantly
alter the structure of the OO design to such an extent that its underlying
elegance is now corrupted.

Have others used the serializer and had the same experience?

Or have I crossed over from being a software engineer to an OO artisan and
the serializer should be seen as a reality check of how MS expects me to
write my software?


Dave A

Dave A
6/30/2003, 2:15:15 PM

0 replies


1 replies , 12/14/2004, 4:43:02 PM
Hello, Is it possible to allow multiple users to input data into one spreadsheet/Excel file at the same time (shared file), and also restrict the information that the users can see and update. Such as lines 25-100 I would like one group to use and see, and lines 100-200 another group. I will also need to prevent any changes from being made to columns B:E. Thank You,

How to restrict cursor placement?
0 replies , 3/27/2007, 7:31:26 PM
I have a spreadsheet with several columns that consists of pulldown menus. In order to keep things neat, I have empty columns and rows in- between all those pulldown cells. I wish to have my cursor jump to the next pulldown to the right and not have to click twice to skip over the empty column. Is there a way to tell Excel to skip over any empty column or row? TIA

I have restricted assess on the view function on all my Word documents. The permission on the documents is set to unrestricted, yet I am unable to look at any document to see what the layout is looks like on the page befor I print it. How do I remove this restrictions. There is a red circle with a hyphen through it on the view function box as well.

restrict calculation
1 replies , 5/5/2004, 9:51:01 PM
Is there any way to limit calculations to a part of a sheet? Or prevent a small area from being recalculated? OSX -- Harvey Products makers of Dinghy Dogs� The Boater's Best Friend Ladies' handbags and accessories Remove thefrown to email me

Harvey Waxman
restricted access
1 replies , 6/22/2005, 5:40:02 PM
This morning I tried to open a Word document I created yesterday. All icons are gray, and I cannot edit the document. Across the bottom it says "This document is locked." I tried to then open another file in Powerpoint. The same thing happened. I created these documents, though, so I should have access to them. Additionally, I cannot create any new documents in any MS Office product. I tried everything from checking my permissions to unrestricting access. I cannot get anything to work. Does anyone have any ideas on how to unblock whatever restricted access has been created in all my MS Office products?

Restricted permissions
1 replies , 11/3/2005, 5:37:35 PM
I created documents in exel and now they are all shown with restricted permission. I don't know how it this happened how can I get rid of this.

Userform: text restrictions
2 replies , 3/28/2006, 5:30:08 PM
Hi, I'm working with a VBA userform; in the fields are only digits and letters must be allowed. How do I make this restriction? Thanks.

Text Restrictions
3 replies , 9/25/2006, 6:54:01 PM
Using Excel 2000 and without having to get into Macros, is there a way to set a validation such that only an uppercase character can be enterted into the cell? For example, the cell would allow an uppercase "X" but nothing else? Thank you for all help / suggestions, -- LPS

3 replies , 5/1/2009, 8:05:01 AM
When I click on links in email messages, I get the following message "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator". I am a home user and have presumably made some incorrect setting. Can anyone help ?

restriction setting
0 replies , 12/5/2008, 9:05:02 PM
Somehow I have a restriction setting on my computer that is office 2003 based. When I click on a link inany office format (outlook, exell, work I get the following error warning with a red & white X symbol: This operation has been cancelled due to restrictions in effect on this computer. Please contact your systems administrator. I think I checked a box somewhere, but now can't find it. Can anyone help?

I would like to use a Visio drawing on a commercial web site I am creating. Will I have problem with copyright on the built-in shapes? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.

0 replies , 8/29/2007, 6:46:02 PM
I have a formula which I entered via Alt/F11 which restricts pasting on a worksheet. IPrivate Sub Worksheet_SelectionChange(ByVal Target As Range) Application.CutCopyMode = False End Sub I'd like to edit that formula so that certain cells within the worksheet can be copied and pasted, but not others. Thanx

Running MS Flight Sim as restricted user
1 replies , 11/28/2004, 7:17:37 PM
Am new to XP but getting there, have set up my kids as restricted users and installed MS Flight Simulator which only I can play unser my User Account, I've tried to set up the kids with access but just get the message that it can only be run from Aministrator, don't want them running riot with full access! Dom

Error in restrictions in effect
2 replies , 9/30/2006, 3:47:01 PM
When I click the link in outlook 2003 , it show : This operation has been canceled due to restrictions in effect ob this compter . Please contact your system administrator . I had been try to re-install the office , but still had this question .

Restricted Cells
1 replies , 2/19/2008, 9:51:27 PM
I have a spreadsheet with the following characters - some columns are inaccessible for input, some cells are protected, there is a section of the spreadsheet that I can't even click the mouse it jumps to the next available cell. Some columns have a weired color - Pink!. Basically it has more restrictions than necessary and I need to modify some of the formulas, be able to add a row and be able to print the way I want. How do I disable these restrictions? or edit so that I can modify it? After all it is mine now.I'm also eager to know how to do all these cool stuff. Unfortunatley, the person who designed this is no longer with the company. Spreadsheet created in Excel 97-2003, I now use the 2007 version. please help -- ab3d4u

1 replies , 8/30/2004, 8:11:16 AM
How can I make a user level in windows 98 wherein there are user rights like in the windows 2000 and XP. I want to grant limited access to users on networked pc. Thanks

Condition not valid for every Restrict or Find call
12 replies , 11/21/2004, 11:35:05 PM
Starting around two days ago for some reason I am getting a "Condition not valid" dialog box every time I run Restrict or Find. This seems to happen regardless of the query or the target items. For instance, all of these snippets give a "condition not valid". Application.GetNamespace("MAPI").GetDefaultFolder(olFolderTasks).Items.Find("[Complete] = False" Application.GetNamespace("MAPI").GetDefaultFolder(olFolderTasks).Items.Restrict("" Application.GetNamespace("MAPI").GetDefaultFolder(olFolderTasks).Items.Restrict("[Subject] <> 'test'" Application.GetNamespace("MAPI").GetDefaultFolder(olFolderTasks).Items.Restrict("[Subject] <> 'test'" Application.GetNamespace("MAPI").GetDefaultFolder(olFolderOutbox).Items.Find("[Subject] <> 'blah'" Application.GetNamespace("MAPI").GetDefaultFolder(olFolderCalendar).Items.Restrict("[LastModificationTime] > '01/1/2003'") It's killing me - essentially everything I have done has been brought to a halt. Anyone have an idea what is happening here? I have tried: SCANPST to clean us the pst different/new PSTs removing all add-ins I have all Office updates Outlook Detect and Repair I am running Outlook 2003 on XP Pro SP2 with all windows updates. thanks, dave

restrict users
0 replies , 3/15/2006, 3:27:30 PM
Is there a way I can restrict users from taking exel workbooks home and share among friends? We have some valuable information in some sheets and would like to prevent it getting out?

sumif with restrictions
7 replies , 9/18/2007, 11:44:01 PM
I'm trying to create a formula that says "if column a=81500 AND if column b=1885, then do a sumif(columnC,"<529999",">539999",columnD). So, basically, I want to do a sumif function but put restrictions on it and only add up those numbers in column D that meet the criteria. To make things more difficult, I'd like the sumif funtion to lookup a range of numbers (ie: 530000 thru 539999) vs. a single number in column C and return the total of everything that matches that range from column D. Any suggestions?

Restricting Input
5 replies , 1/24/2005, 9:35:33 PM
Ok, I'm on a roll here. Could someone please tell me how to set up a cell restriction that will only allow data input if another cell is "empty" or has a certain value? Kind of like an IF function, only when "true" exists, I can input any value, and when "false" exists, I must leave it blank. Thanks in advance. Randy,

Randy Vieira
Dear All, I am using MS Office 2003 EXCEL and have already tried to and installed an EXCELff hotfix sent to me by Microsoft. The EXCELop file would not install. This is all due to the following problem with EXCEL 2003: When I attempt to open my EXCEL files with password protection on them I receive the following message: Permission to this workbook is currently restricted. Microsoft Office must connect to to verify your credentials and download your permission. When I click on the OK button I see the initiation of a new box indicating and trying to download the permission, but this quickly closes and then I receive the following message: Your Information Rights Management configuration is invalid and needs to be repaired. For more infomration, contact your system administrator. I am the system administrator and now I need your help to repair this. All of this happened after I removed The Norton Utilities, Antivirus and Internet Security completely from my computer. Please help me ASAP... This is time critical! Thank you very much for any light you can shed on this!

Ofiice license restrictions
4 replies , 8/23/2003, 2:21:58 PM
Hi! I have a question for you. Presently where I work we are not using an Ms Office product. We are considering migrating to office 2000 pro (XP is not compatible with our legacy software). The staff work in teams, one boss with his/her secretary. If I install office 2000 Pro on the secrtary's workstation can I also install the same licence on her boss's laptop. The question is very straight-forward but the answer seems to be hard to find. Maybe someone here familiar with MS's license policies can help me. Thank you in advance for your assistance.

How to restrict access our DB on SQL server.
2 replies , 1/10/2005, 12:49:45 PM
Hi, How can we restrict our DB if connecting thru other applications like SQL query analyzer, Excel & even Enterprise manager? but this DB should be accessible by our application (from front end) only... I learned about "Application Role" in SQL server 2000 but to apply this we will have to change our code thousand places. Have any idea...Pl. do suggest??? Thanx in advance!!!! Regards, Paresh.... -- Message posted via

paresh goyal via
Restrict % to 100
2 replies , 7/30/2004, 7:39:49 PM
I have a spreadsheet where a calculated field can be greater the 100% for reasons that I cannot change. How do I write code to restrict the dispaly to be maximum 100% Thanks, Robin Chapple

Robin Chapple
restrictions in effect
1 replies , 9/6/2003, 9:38:00 PM
I attempted to run the disk prompted by XP on my 98SE 333 hgz computer. Error generated is "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator. I am the admin. I beleive I have OKed on windows to allow. Would my zone alarm keep this from happening? I am using a broadband router for internet connections and both machines are sharing at that level. Midmo

restricting "set time and date" properties
0 replies , 9/6/2004, 10:14:05 AM
hi, I have a computer on my company that needs to have its time/date properties locked up. The question is that the machine is running windows 98... I already tried to use poliedit, but I didn't found any line refering that particulary property window. Thank you. Z�

Computer Restriction
2 replies , 1/7/2010, 8:36:02 PM
When I received a www. address link in an email, and when I click on that link, I receive the message "This operation has been cancelled due to restrictions in effect on this computer. Please contact your system adminastrator." My computer is not part of a network and has no adiminstrator. How do I corrrect this restriction message? -- Rockhill

Outlook Restrict on SentOn (using Between)
2 replies , 9/28/2009, 2:57:58 PM
Hello all, I am trying to figure to the proper syntax for using Restrict on the SentOn field. I need to restrict between two dates, but so far nothing is filtering to the exact date range I'm looking for. I have tried: Set mItemCollection = mItemCollection.Restrict("[SentOn] > '" & dteStart & "' AND [SentOn] < '" & dteEnd & "'") Set mItemCollection = mItemCollection.Restrict("[SentOn] = '" & dteStart & "'") Set mItemCollection = mItemCollection.Restrict("[SentOn] Between '" & dteStart & "' AND '" & dteEnd & "'") Thanks for the help.

hyperlink restriction
2 replies , 12/30/2009, 11:04:01 PM
I receive the well known response "denied due to computer restrictions, see administrator" I have looked but not found a solution when trying to use a hyperlink within word to anther document or powerpoint on my computer or to an online webpage. I am NOT using outlook, etc.: Windows 7, Office 2007, IE8 remember I am looking for another file on my computer, word and excel and powerpoint. Any help please would be appreciated. -- SciRx

How do I remove restriction if I didn't put it on?
1 replies , 9/20/2006, 11:36:02 PM
Some one please help me. I have tried to remove the restriction with what HELP said but the things are not high lighted.

conditionally restricting values
2 replies , 4/23/2004, 8:12:06 AM
Hello, I want to restrict values in a particular column based on the value in other column. For eg. if column A has value int then column B should be restricted to values 1,2,3,4,5 if column A has value bool then column B should be restricted to values true and false. How do I achieve this ? Can I use macros to do this? How? Thanks

disable object model restrictions
1 replies , 11/17/2003, 3:08:33 PM
how do i automating the Outlook or CDO object models by using the administrator features to disable object model restrictions? where is this located. BTW- sorry for double post. this group was giving my reader some problems.

Hyperlink restriction
0 replies , 11/27/2008, 6:51:01 PM
I am using Office Home and Student 2007 with Vista Home Premium SP1 When I click a hyperlink I now get the following message box, “This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator.” This happens in Word, Excel, and OneNote; and for links to my computer files and to internet addresses. How do I get the hyperlinks to work again? ||

Restricted access to the sheets
6 replies , 8/21/2007, 8:54:27 AM
Hello, I'm using Excel 2007 and I have a task to make an excel dokument where different user of my company will have access only to their own sheets not but to the sheets of their colleague. Is there a way to accomplish this duty? Ivan

Hello I am working with an Outlook third party solution that we are using for our Guest Services department. We are storing Contacts, their related Service issues, and their related Notes as items on our Exchange Server and accessing through customized Outlook forms. Relationships Contacts->Service Issues->Note 1 contact to many service issue 1 service issue to many notes The Service issues of a given contact are displayed in a listview on a custom Contact form The Notes of a given Service Issue are displayed in a listview on a custom Service Issue form. My question is regarding the performance of the find and restrict methods. We currently have 50,000 contacts, 52,000 service issues, and 240,000 Notes. When you open a contact which triggers the population of it's Service Issues, it searches through the available 52,000 using the find method. This can take upwards of a minute. Upon opening subsequent contacts, Outlook appears to use a cache since the search only takes around 3-4 seconds. However, this "cache" goes away after a period of time. Then the population of Service Issues again takes up to a minute. You can imagine how long the initial search takes when finding the associated notes of a given Service Issue Are there any settings on the Exchange server to utilize the cache more efficiently? Is there any sort of indexing available? We are using an ID field (20 to 30 bytes) as the key to the given item. Is the size of this ID field an issue Any help would be greately appreciated Thank you Dan