CheckBox Code to copy & paste range
Mobys of VBA,
I 'm trying to write what I assumed was a simple copy & paste procedur
using a checkbox value as the trigger. I have tried numerous variations
but to no avail. I get no error messages, I also get no desired results
except that everytime I run the code it does unprotect and protect th
worksheet and it always clears the contents of rng2.
The two named ranges (rng1 & rng2) are unprotected and the same siz
and configuration (i.e. A20:A22, A43:A45 respectively) , but they ar
on different sheets. Thanks for any help
Here is my best code to date:
Private Su...Difference between Teams and BUs
Can anyone explain the differnce between teams and business units in MS CRM
Business Units are used to create your organisational structure within CRM.
Users then go into those structured Business Units.
When you want to share information with teams of people across multiple
business units, rather then change individual security permissions etc... you
create a team.
So teams are just groups of users from one or more Business Units that you
want to be able to share views/records easily.
> Can anyone explain the differnce between t...Saving changes to the default tab in a document
I seem unable to save a change to the default tab setting in an individual
document. I make the change (ie. from 0.5" to 0.25") and save the document.
Upon restarting Publisher and reopening the document the default tab may or
may not be 0.25"! This is extremely irritating since when the default tab
changes back to 0.5" it does so in all text boxes in the document thus badly
messing up the document layout.
Is it me or is it Microsoft???
Did you compose this publication in 2000?
Custom tabs that you previously set in Publisher 2000 are not saved ...Can Publisher do duplex printing???
I need to print a monthly bulletin on a Ricoh 1075 printer/copier. The
printer will do duplex printing: I created a Word document and it prints
My Publisher document is 16 logical pages 8.5x11 which I want to print
duplex 2-up on 4 11x17 physical pages. I can get the pages to print
2-up a-ok, but I can't get the pages to print duplex. I've tried every
possible print layout setting there is....duplex, booklet, you name it.
No matter what I do the pages come out one sided.
There must be some trick I'm missing, but what could it be? I searched
the MS Know...sending v cards, changing address settings
Hi i use outlook 2003, When I send a v card, the address fields
change to businness, which is normally blank. I have set the home address as
the address to use as mail address, but still this happens.
I tried forwarding the contacts, not as v cards, which does not have the
same problem, but found this duplicates the contact in my outlook.
...Change the recordsource of a subform that is on an unbound main fo
I know there are many appends on this but I just can't get this to work.
I have an unbound main form (Main). On it are several subforms. The first
subform (Vehicle) contains a summary of the vehicles. When I click on one of
the vehicles, I would like the second subform (Vehicle Allocation History) to
display records for the vehicle selected in the Vehicle form. Below is my
Dim VehAlloc As Control
Dim Main As Form
Dim VIN As String
Dim SQL As String
Set Main = Forms("VehicleSummaryForm")
Set VehAlloc = Main.VehicleAllocationHistory
VIN = Me!VIN
SQL = ...Help! How do I change this back to a printed publication?
I have Publisher 98 and I was trying to save a file so that I could email a
copy of my newsletter to one of my subscribers. She doesn't have Publisher,
so I thought to save the file as an HTML file and mail it to her that way.
Only now, I can't bring my file up on a two page layout view anymore. And I
can't get it to print right either! Help! I just need it to go back to a
regular publication but, for the life of me, I can't figure out how to do it!
Somebody, please help me! How do I undo this?
You could make the page length longer to accommodate the two pages.
Or...Splitting bills on Credit Cards (restaurant, etc)
I have the common situation where myself and some friends
would go out to dinner. Normally we cannot split the
bill, so one of us uses our credit card, and the others
pay their share in cash to the payer.
How should this be represented within Money 2004, using a
Credit Card account & a Cash account.
Bill is $100. Your share is $22. You pocket $78.
Transaction into credit card account is split like this:
Food:Dining Out $22
Transfer:(pocket change account) $78
Total transaction $100
"Nige" <email@example.com> wrote in message
We are having an issue with LPR printing using our software in conjucntion
with a Windows 2008 server which is preventing us from being able to flash
images to a printer from our application.
We use Universe, SB+ and SBClient and would use the DOS shell from inside
SBClient to use LPR print commands to send the images to the printer, this
has worked fine on all other Windows servers but not 2008. What happens is
when you drop to DOS you can browse to the %systemroot%\system32 folder and
do a dir but you cannot see LPR. If you do the same from a normal command
prompt the file ...Change User Name Spellings
Is it possible to change username spellings in GP 9.0? If yes then how?
You can change a user name at any time. You must log into GP as 'sa' and
then go to Tools > Setup > System > User.
Dynamics GP MVP
Flexible Solutions, Inc.
"create_share" <firstname.lastname@example.org> wrote in message
> Is it possible to change username spellings in GP 9.0? If yes then how?
Are you talking about the publicly displayed user name or the ID the user
...Why do cells in Excel print shorter than displayed on-screen?
When I type a lot of data in a given cell (textwrapping is on), the entire
contents of the cell display correctly. But when I print the worksheet, the
cell height appears shorter -- truncating my text.
What's up with that? And how do I fix it without adjusting every cell
manually (which screws up my display)?
...Saving Folder Views
Does anyone know if it's possible to save the mail folder view in the left
hand column of Outlook? I have about 12 IMAP accounts that I use and each
time I open Outlook I have to expand all of the views to how I want them -
takes a while to do each time!
Thanks - Carl.
Version of outlook? See help, about if unsure. Do you have the latest
Generally, no, it either always expands or never does or your expand state
is remembered. Some SPs added it... so make sure you have the latest.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hou...Why necessary to change list price in IM and Ext Pricing?
I have over 4000 items to change the list price of. Big problem for 2
1. How do I start to change a couple of weeks before effective date because
I can not possibly change them all in one day?
2. Why do I have to change the list price twice? Once in IM and once in
extended price? I can not believe a system such as this would make price
increases so difficult?
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...How do I change the default font for comment boxes in Excel
How do I change the default font for comment boxes in Excel
You can change font size and colour by going into
Control Panel>Display>Advanced and select Tooltip from the Item drop down
(this is in Windows XP, might be slightly different menu selections in other
Howevevr, I think Excel will still use the default font of Tahoma, but take
the other attributes from those as set above.
"cljforbes" <email@example.com> wrote in message
> How do I cha...Changing Title Bar of a Wizard
I have two wizards (CPropertySheet's) which both have the same property
page. The title of this page, however, should be different for each
wizard. In the page, whenever I try to call its own SetWindowText() or
the wizard's SetWindowText() upon being set active, it just gets
replaced by the caption that's set in the resource. I've tried setting
the text in OnSetActive() and OnInitDialog(), but it will change it,
but in a split second it will change back to the caption/title that's
in the resource again.
However, just to test it out, I tried putting a button on the page tha...Can I Edit fonts, colors of Mail Folder titles?
Running XP Home Edition and Outlook 2003 11.6358.6360
SP1, part of Office 2003 Professional on a Dell D500
Latitude. Would like to be able to highlight Mail
Folders with different colors, bold and larger fonts,
etc. Is there a way to do this? IMHO would be a great
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, rward asked:
| Running XP H...Credit card reporting
Is there any kind of reporting for EDC settlements available for RMS? I need
a way to have our stores fax something that indicates how much the settlement
for each day was.
I can't find anything in the manager.
Larry why dont you have them run a tender report for that day. Make the
tender for credit cards and have them send that to you by email. Hope that
> Is there any kind of reporting for EDC settlements available for RMS? I need
> a way to have our stores fax something that indicates how much the settlement
> for ...Question about Excel (Office) auditing/changes
I have a document that will need to be posted on a website available for
users to download & change/approve.
The approval process will not make any changes at all to the document.
However, I do need to know they've opened the document.
Is there a way to get the name/machine/ip or something regarding who
opens a file and when they open it?
If so, I would like to do something like that, and either write it to
something in the spreadsheet or as an audit trail in a database.
If there's no way to do this, I am considering writing a small app that
requires them to sign in (somet...Bus. Card changes font when I change print copies / page. I save
Please use this space top fully ask your question. And we need details.
MVP Microsoft [Publisher]
"Grateful" <Grateful@discussions.microsoft.com> wrote in message
"JoAnn Paules [MVP]" wrote:
> Please use this space top fully ask your question. And we need details.
> I modified a design option in business cards. I created it as 1 copy / sheet. I saved it. When I try to print it as 10 / sheet, the font and font color didn't save. I went to styles and formatting...Can't Send After Changing From/Reply-To
I am using Outlook 2003 and Exchange server 2003 to try to send a
message From public folder with the replies going to the same public
folder. It utterly fails.
I created a public folder under Exchange called ContactASA and gave
myself "Send on behalf" priviledges. I then created a new message in
Outlook, set the From field to ContactASA, and set the "Have replies
sent to..." (reply-to) set to ContactASA. When I send the message to
my gmail account I get the following error message:
Your message did not reach some or all of the intended recipients.
S...Change Exchange 2003 Server Name
I am researching if it is possible to change the name of our Exchange 2003
server. I've heard this is possible (perhaps incorrectly) with Service Pack
2, but I can find no documentation of this in the release notes.
Not changing out servers -- it will be the same server, and no other changes
will be be made, just that we want to change the name of it, say, for
example, from EXCHANGESERV to EXCH.
Is this possible (with service pack 2 or without)?
No, it is not possible to change the name of the server. At least not if
you want Exchange to still function afterwards. Sorry....How to copy page setup
I need to open a new worksheet for a new year. (The year starts July
I have copied the previous year worksheet to a blank worksheet in
order to keep the formatting and formulae.
How do I copy the page setup for printing?
why not simple save a copy of the previous file strip out all the
detail you don't need and build up to your new template?
just a suggestion
Robin Chapple wrote:
> I need to open a new worksheet for a new year. (The year starts July
> I have copied the previous year worksheet to a blank wor...How can I Change recurrence settings with OUT updating details????
I have a recurring appointment that I use to keep daily notes. I set it up
for 4:30 and would like to change it to 3:30 -- however, when I actually
make the change it clears ALL of my previous entires notes. So I lose about
2 years worth of notes when I make this change. Anyone know how I can make
the change without this loss of information?
Create a new recurring appointment for 3:30 and end the recurrence of the
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name ...Updating credit card merchant payments in GP
Can any on help. I need advice on how to set-up GP so that credit
cards bank payments offset the credit card sales.
how are credit cards treated ( receivables or cash)? I suspect they
should be receivables but how do I apply the payments fro the bank to
reduce the balance in these accounts?
Setup/create some credit cards (for payments received from customers) as
follows: Tools>Setup>Company>Credit Cards = accepted from customers = bank
Enter manual payments to your customers AR accounts = payment type = credit
card, select the credit card(s) you created ab..."SBS & EBS Users" group name change on LinkedIn
For those of you that are members of the "SBS and EBS Users" group on
LinkedIn, we have changed our name to reflect the change in EBS status
as well as to appeal to a wider audience. We are now officially "Small
Business IT Pros."
And if you're not already a member, feel free to join us at
We currently have over 600 members and are growing daily.
Bradley J. Dinerman, MVP - Enterprise Security