UserInterfaceOnly #3

Hello.  Is there a way to separate certain ranges from the protection of 
UserInterfaceOnly, such that the user can input information into certain 
cells?

Kind regards,

D.Parker
0
DParker1 (41)
5/17/2005 5:25:48 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
600 Views

Similar Articles

[PageSpeed] 54

Unlock the cells and then both the user and the code can change these cells.

D.Parker wrote:
> 
> Hello.  Is there a way to separate certain ranges from the protection of
> UserInterfaceOnly, such that the user can input information into certain
> cells?
> 
> Kind regards,
> 
> D.Parker

-- 

Dave Peterson
0
ec357201 (5290)
5/17/2005 7:51:27 PM
Reply:

Similar Artilces:

AutoCAD Architectural Desktop 3.3 & Outlook Journal
I would like my Outlook Journal to track my activity in AutoCad2002 or Archi Desktop above. That way I can have outlook record what projects I have been working on and when. The AutoJournal2000 did not work it was looking for Autocad 2000, and thats not what we're running. If someone could help me out that would be greatly appreciated. ...

Vacation Due #3
Duane Thanks tor your reply. But I am still not getting result?? Mr Kusleika and yourself are on the right track. My Excell skills are not to that level yet but I am getting ideas from your replies. It would be ideal to show only one of three answers to formula; 40 hours for 6 months 80 hours Due Jan 1st after 1 year anniversary 120 hours Due Jan 1st after 7 year anniversary I am getting the idea my question does not have simple solution or I am posting it incorrect. But I appreciate your response just the same . Thanks :confused: -- SilverM78 ---------------------------------------------...

CRM 1.2 Database on a server, and CRM 3.0 installed on a new server... how to move content?
Hi, does it possible to move the content from a CRM1.2 database to a new CRM 3.0 installation? I can move the accounts and some information using CSV files, but not the activities. what can I do? thanks. Jerome. ideally you would upgrade the original system to crm 3.0 as well then use a tool like scribe migrate to move data between the two systems ======================= John O'Donnell Microsoft CRM MVP http://codegallery.gotdotnet.com/crm "Jeje" <willgart@hotmail.com> wrote in message news:%23NveHq1iGHA.4344@TK2MSFTNGP05.phx.gbl... > Hi, > > does it p...

3 fold printing
When printing a 3 fold document, the 3rd panel prints short. When viewing it in normal mode, it looks fine. But when Print Preview, it also shows the shortness in the right margin. How can I resolve this issue? Sounds like it's set up for a ink jet printer which cannot print to that area. Ink jets can have up to an inch of no print area, laser about 1/4 inch. Set it up for another printer. "HpyTrvlr69" <HpyTrvlr69@discussions.microsoft.com> wrote in message news:E0FF331A-8003-4BD9-B1A5-6E18A97C0013@microsoft.com... > When printing a 3 fold document, the 3rd panel ...

Exchange 2003 logs #3
Hello I am using Exchange 2003 Ent. and have a huge amount of log files collecting in one of my storage group folders. I have 5 Exchange databases in this folder. The logs are titled "E0200A00.log", "E0200A0B.log", and so on. They are taking up 12 gigs of space and go back 6 months. What prpose do these serve and is it ok to delete some of the older log files? Thanks, J 6 months? when was the last time you did a backup? those are trasaction log files; they get deleted when you do a backup of your store(s) How to remove Exchange Server transaction log files http://su...

Outlook 2003 error message #3
I am recieving this error message when i attempt to send email messages to any other site outside of my own email provider "I.E. myself" Any help? 530 delivery not allowed to non-local recipient, try authenticating Keith <Tabo2@rennlist.com> wrote: > I am recieving this error message when i attempt to send > email messages to any other site outside of my own email > provider "I.E. myself" > > Any help? > > 530 delivery not allowed to non-local recipient, try > authenticating Did you do what the message requests? Did you check the au...

Category #3
When I go to spending by category I have see a message that I have 1 transaction that is not assigned a category but when I click on "Assign a category" I get a prompt that says "You have no transactions for the item you selected" The amount is 20.00 I have searched for all transactions for that amount and there are only 4. 3 of them have seperate categories and one is a split category. How can I fix the message??? ...

Making a list #3
That works fine except it dosnt update the new list automatically whe the original list changes but apart from that its excellent and ver useful, many thanks -- scottymellot ----------------------------------------------------------------------- scottymelloty's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=380 View this thread: http://www.excelforum.com/showthread.php?threadid=27018 ...

subtotal #3
I wonder some Excel experts out there will show me how to bold and add color to the subtotal amounts. When I use the Subtotal function, the title of the subtotal is bolded but not the subtotalled amounts. I have to use the bold format as well as a color to distinguish the subtotal lines only from the list. thank you so muc for your help! Hi Vickie depending on your numbers you could use conditional formatting to do this select the column that you're totalling choose format / conditional formatting choose cell value is greater than or equal to type in a number just larger than the...

(APPZ) Ashampoo.UnInstaller.3.v3.1.3.0.incl.Keygen.WinAll-LAXiTY
=ybegin part=1 line=128 size=6003 name=Ashampoo.UnInstaller.3.v3.1.3.0.incl.Keygen.WinAll-LAXiTY.nzb =ypart begin=1 end=6003 fi���J�������gL[XZLJ��������gL���WbLJih74fKnym~�zoJ���JzlvsmJLWYY����l��YYn~nJx�lJZXcYYoxLJL����dYY���X�������X���Yn~nY���Y���W ZXcX���Lh74f���J�����gL����dYY���X�������X���Yn~nY\ZZ]Y���Lh74JJf����J������gL��������bbj������W����X���JR��������SLJ����gL[\`_b baaZ[LJ�������gLRkzz�SJk�������X�s��������X]X�]X[X]XZX����Xu�����X���k��Wvk��~�JWJPM�\\ek�������X�s��������X]X�]X[X]XZX����Xu� ����X���k��Wvk��~�X���PM�\\eJ�[Y]�JR[Y[SLh74JJJJf������h74JJJJJJf�����h���X������...

CRM 3.0 Licensing Question
Folks: I am new to CRM and have a question on licensing. Here are our licensing details: Microsoft CRM 3.0 License type : Professional Server Licenses : 1 User Licenses (total) : 100000 User Licenses (Used) : 85 User Licenses (available) : 99915 Does this mean we have User Licenses for 100K users and we pay yearly for this many users? Thanks ! CRM 3.0 used the volume licensing model, so the key unlocks 100,000 seats, but you pay for how many you use. You should be reporting to your LAR/Microsoft how many seats you are using annually. Dave ...

Exchange 2003 Question #3
Dear all, I have upgraded from Exchange 5.5 and notice that I miss the feature where I can clean/delete mail based on certain criteria from users mailbox via the System Manager. Is this feature still available in Exchange 2003, If so, where is it? Thanks. Regards, Kueh. You can use ExMerge to remove emails based on certain criteria (ie. attachment name, subject, etc). http://www.msexchange.org/tutorials/MF013.html "KA Kueh" wrote: > Dear all, > > I have upgraded from Exchange 5.5 and notice that I miss the feature where I > can clean/delete mail based on ...

3 variable xyz scattergram
Hi there I need to create a 3 variable, and 3d (rotatable optional) scattergram using a logartihmic scale on the x axis. x axis range: 0.1 - 7,000,000 y axis range: 0 - 1 z axis range: 0 - 7,000,000 Can you please help. Thanks The 3d chart in a LINE chart the x-values are treated as categories not numbers. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "tsharp" <tsharp@discussions.microsoft.com> wrote in message news:0CA8B949-EA7B-4551-A54C-F9B5B4B3D599@microsoft.com... > Hi there I need to create a 3 variable,...

Microsoft .NET Framework 3.5 Service Pack 1 and .NET Framework 3.5 Family Update for .NET versions 2.0 through 3.5 (KB951847) x86
hello, this update tried to install when i logged off of my computer. apparently it failed. now, some other software that relies on the .net framework will not work. i tried to reinstall it from windows update, but i get the message below saying it was not installed Microsoft .NET Framework 3.5 Service Pack 1 and .NET Framework 3.5 Family Update for .NET versions 2.0 through 3.5 (KB951847) x86-- i searched for kb951847 which i did not find anything that was helpful i have windows xp pro sp3 installed. i have no clue what to do. any help would be greatly appreciated...

Cannot start Outlook 2003 #3
Hi , When I start Outlook I get the following error message Unable to open your default email folders .The microsoft exchange server computer is not available .Either there are network problems or the Microsoft exchange server is down for maintenance . I can get my email if I log from another machine .I have recreated my profiles ;applied service pak1 .Still no luck . Please reply . Thanks Mibsun mibsun <mibsun@discussions.microsoft.com> wrote: > When I start Outlook I get the following error message > Unable to open your default email folders .The microsoft exchange > se...

product key #3
Is there anything I can do if I've lost the cd-case with the product key on it? I had to reinstall windows and now I can't get publisher back on my computer. Call microsoft Scott wrote: > Is there anything I can do if I've lost the cd-case with > the product key on it? I had to reinstall windows and now > I can't get publisher back on my computer. (425) 635-7056 -- JoAnn Two things are aesthetically perfect in the world - the clock and the cat. --Emile-August Chartier "Steve in NC" <dtp2webSPAM@netscape.net> wrote in ...

CRM 3.0 Drop Down List Attribute
Where are the 'Drop Down List' attribute options and their associated indexes stored in the CRM database (CRM 3.0)? Thanks! They are stored in the stringmap table. -- Patrick Verbeeten (MCPD) CRM/.NET Consultant Aviva IT Tools for CRM Developers and Administrators http://www.patrickverbeeten.com/Tools.aspx "Banner" wrote: > Where are the 'Drop Down List' attribute options and their associated indexes > stored in the CRM database (CRM 3.0)? > > Thanks! ...

Reporting #3
I'd really like to know how many messages are sent/received from my Exchange 2003 server. I've set up a MOM server with the Exchange extensions, but I'm getting the "no data to report" message for all reporting. Does anyone know an easy way to find the number of messages sent/received per day? Thanks, Joe ...

Hi #3
Hi I can't seem to attach any gif's at all from the "intert/picture" option. I've changed the options so that the emails are HTML, then I changed them so that they are rich text and used word as the editor. Nothing seems to be working and I keep getting this error. "An error has occured in this dialog. Error: 195 'undefined' is null or not an object." Please help?!?!?! Sharn Hi, The following Knowledge Base (KB) article addresses the issue that you are having. 311750.KB.EN-US OL2000: Error Message: Error 195 'Undefined' Is Null or N...

CRM 3.0 Mobile and Product sales
Hi, How to sell product with CRM mobile ? When I create New Opportuni in with CRM mobile client Device i can not add new opportunity products! When the Opportunity ir create with CRM and then sincronized to Mobile device then I can Only read product information. Is there some solution to add end change oportunity products with in CRM mobile? Martins ...

routing numbers #3
Third time is the charm maybe... How do I change the routing numbers on my accounts in Money 2004? If nobody knows... OK. I just need to know if there is a way! What is this routing number used for? Epay? "Stephen" <guzzetti@xmission.com> wrote in message news:10b6301c3f36c$7ab537a0$a501280a@phx.gbl... > Third time is the charm maybe... > > How do I change the routing numbers on my accounts in > Money 2004? If nobody knows... OK. I just need to know > if there is a way! All accounts have a routing number and account number. The routing number can ...

Send As permission #3
I am trying to grant a user Send As permission. I enable Advanced view, go to the Users object that I want to grant access to, go to the security tab, click advanced, and click Add, but I do not see Send As permission there. I can grant full mailbox access, but the grantee still shows "Sendt on Behalf Of" in the e-mail when they send for that user. What did I miss? Never mind....you have to do it on the domain controller, not from an exchange server.... "Tom Felts" <tfelts@mckennalong.com> wrote in message news:e3MFRAbUFHA.3312@TK2MSFTNGP09.phx.gbl.....

Security #3
When restrictions are placed on profiles, sometimes when the user logs on he may get a pop up window saying they do not have security privileges, they then click ok, and they are able to gain access to their specific profile. Is this normal? And how can I stop that pop up window from coming up? rcr, Can You tell where exactly this is happening. This generally happens in the Smartlist window. Here is the resolution just in case its happening in Smartlist 1. Go to Security and Select the User for whom this issue is happening 2. Select Product as FieldService, Type - Window and Series ...

how #3
I had an old computer about 5 yrs ago that had microsoft money on it..I used it and then about a year ago I purchased a new computer which at that time came with the quicken program instead of microsoft money...back then you helped me transfer the quicken program to microsoft money so that I could continue to use my accounts...I now have the same problem...We had to do a system recovery and I have lost my microsoft money program...once again it is quicken which I do not want...I have backed up my microsoft money to floppy disks...but I once again need to know how to get the money pro...

How to calculate how many cells have a value of less than 3?
What formula can you use to get the total number of entries from within a range of cells that contain any value 3 or less? I have a large numbers of results in a spreadsheet (results can be anywhere from 1-10) and want to be able to easily get the total number of entries that are either 1,2, or 3. Thanks... =countif(a1:b99,"<=3") is one way. FISH wrote: > > What formula can you use to get the total number of entries from within a > range of cells that contain any value 3 or less? > > I have a large numbers of results in a spreadsheet (results can be any...