edit a comment while protect sheet is on the cell is unprotected
i want other useres to b able to enter /edit a comment in an unprotected cell
when protect sheet is on
When protecting the sheet enable "Edit Objects" in the allow users to list.
Gord Dibben MS Excel MVP
On Thu, 4 Feb 2010 10:20:02 -0800, Rubber 4 u
>i want other useres to b able to enter /edit a comment in an unprotected cell
>when protect sheet is on
...How do I copy page setup from one worksheet & paste into new shee.
I have set up a template in one Excel worksheet and want to be able to paste
it into new worksheets. My problem is that I the have to adjust the page
setup in each new worksheet. Is there a way I can copy the page setup into
the new worksheet?
if this sheet is the first in your workbook try:
- select this sheet and the other sheet(s). Hold down the CTRL key to
group the sheets
- goto the page setup dialog and simply hit OK
"Rasc0" <Rasc0@discussions.microsoft.com> schrieb im Newsbeitrag
news:7E2EB66D-90F8-49F6-9043-62CBB9CCE602...power spreadsheet users wanted for beta tests
The makers of Personal Audio Link, a cellphone_to_VoIP application,
are offering six months free Vonage telephone service to beta clients
for a new "remote cellphone to PC" sofware.
They are looking for power spreadsheet users to sample the software, in
exchange for the free Vonage service and comments to the website's
user forum re: likes and dislikes, suggestins, etc.
It allows users to send and receive e-mail by voice, via cell phone,
interact w/ & parse records in their Excel spreadsheets by cellphone,
from a cellphone, g...Auto numbering of spreadsheets
I have created an elec application form for use on a telephony section. Each
time a user enters the form when a customer rings, I want the form to be
numbered automatically, so that each form has a reference number. There is
the possibilty that more than one user will open the form at any one time -
will they still have seperate IDs?
Can this be done? Any help appreciated...
"abfabrob" <email@example.com.NO_SPAM> wrote in message
>I have created an elec application form for...Too long time to open My Computer folder
It takes some 3 minutes to open My Computer folder. The searching torchlight
animation is shown all this time. The OS is Windows XP x64 Pro, laptop with
Turion TL-56 processor. I cannot figure out the reason for this. The other
tasks and applications run quite fast.
...wHY WON'T MOST DOWNLOADED .XLS FILES OPEN IN VERSION 5.0 ?
I am still using Excel Version 5.0. (Ha-Ha) When I try to open a .XLS file
from a Website, I get an error message reading something like: "not a valid
Is this because 5.0 is so old, or is there another issue here? How can I
deal with this?
When xl97 was released, the format of the .xls files changed. xl97 (and above)
can read those old file versions, but that old version can't read the newer
Time to visit eBay (xl2k should be available/cheap)????
Al the Elder wrote:
> I am still using Excel Version 5.0. (Ha-Ha) When I try to op...Disappearing Attachments
All of the sudden Outlook is not letting me receive attachments. I get the error message
OE removed access to the following unsafe attachmnets....
I know these attachments are safe. Any ideas on why this is happening
this is due to the latest patch which u might have apply
using Windows Update. Simply do a mail forwarding (no
need to enter a recipient), u will find all the
>All of the sudden Outlook is not letting me receive
attachments. I get the error message
>OE removed access to the following unsafe
attachmnets.... ...Error restoring GP to new server
I installed a new server and installed SQL 2000 and greatplains. I copied
the database backups and tried restoring the old DBs to the new server. I
am getting the following error when trying to access the companies:
A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' failed
accessing SQL data
Any help would be greatly appreciated.
Did you install all of the products on the new server?
"Bruce Wayne" wrote:
> I installed a new server and installed SQL 2000 and greatplains. I copied
> the database backups and tried restoring the old DBs ...new mail not going to the top
Using windows explorer - vista - new mail goes sny place within the older mail.
"lois" <firstname.lastname@example.org> wrote in message
> Using windows explorer - vista - new mail goes sny place within the older
You can sort incoming mail in several ways, as single messages or group them
You can also sort it by each individual column, Subject, From, To, Receive
etc simply by clicking on the title of the column heading name, once to sort
...Setting up Word to automatically open in Standard mode, zoom=page margins
I've tried to find ways to handle this through the normal.dot file and can't
find it... Word wants to open in layout mode and 200% zoom, forcing me to
manually select mode and zoom.
Any way to get Word to do what I want instead of what it wants?
Thanks for your time.
Word will open each document in the view and zoom it as last saved in.
The onyl way to have a particular view happen every time is to create an
AutoOpen() macro that specifies the view you want.
Turn on your Macro Recorder and record yourself setting the view and zo...creating spreadsheet with colunms for names adresses & zipcodes
How do I create a spreadsheet with seperate colunms for names, addresses &
zipcodes? I want to use this with streets & trips so I can map several
adresses at one time.
I don't understand the question, if you want to create a spreadsheet you
need to type in headers
for each needed column, then put the names and addresses in their respective
"neilabu" <email@example.com> wrote in message
> How do I create a spreadsheet with seperate colunms for names,...Searching for data and inserting new rows
I have a spreadsheet from one of our clothing suppliers, which I am going to
import into our database for ordering. The format is:
Part No. / Description / Price / Size
The size is given as a range (i.e M-XL) for each item of clothing
What I want to do is analyse the size range and extract what sizes are
available, then insert new rows for each of these sizes
So, M-XL becomes:
Part No/ Description / Price / M
Part No / Description / Price / L
Part No / Description / Price / XL
I've got over 800 individual lines to do, so any help on automating this
task would be helpful!!
Thanks ...Maximum spreadsheet sort limit
Can someone tell me if Excel 2000 has a maximum sort limit in terms of
number of rows? The reason I ask is that the spreadsheet we are currently
using is 17000 or so rows and when it is sorted there is still a large number
of rows that appear to be unsorted.
Thanks in advance for any assistance
I just did a simple test and loaded 60,000+ rows and sorted them.Looks
perfect to me.
There must be some other factor affecting it.
(remove nothere from the email address if mailing direct)
"Paul Townsend" <PaulTownsend@discussions.microsoft.c...New to Outlook #9
Some E-mail gives me an error stating error with previewer. MS Office Outlook
message and item previewer. How do I correct this problem, and be able to
view my mail?
Danny <Danny@discussions.microsoft.com> wrote:
> Some E-mail gives me an error stating error with previewer. MS Office
> Outlook message and item previewer. How do I correct this problem,
> and be able to view my mail?
Using Outlook 2007? Always state your Outlook version.
What distinguishes the mail that does not give you the error from that which
does? Do you have attachments? If so, what type of documen...How do I get year to date earnings on a payroll spreadsheet(what'.
I am trying to create a payroll spreadsheet. I want to get the formula for
year to date.
I would rather not use a 52 column sheet with totals. How can I add the
change each week without using a large sheet?
If I can offer an opinion: regarding payroll, keep as much information
as you can. Payroll is sacred- people literally live by it, and they
are VERY concerned that proper records are kept. A Fortune 500 company
is judged by its stock price; small and even medium sized companies are
judged by whether or not they met payroll.
My suggestion is to allow the spreadsheet to be as large as i...Identify closed/finalized records the month they were opened Acces
I have a query, qryClosedRecords, where I need to report if the records
finalized/closed the same month they opened.
So if it opened #10/05/2009 06:05# and finalized/closed #10/25/2009 21:59# I
need to mark it as being finalized/closed the month it was open.
Field for Date Opened = qryClosedRecords.open_time
Field for Date closed = qryClosedRecords.finalized_time
And if it opened #08/03/2009 21:25# and finalized/closed #9/23/2009 12:45# I
don't want to count it because it didn't finalize/close the month it was
I need to do this in a query becau...Excel shows only one sheet in taskbar
When I open an excel worksheet it displays in the taskbar but when I open
subsequent sheets they are not displayed in the taskbar.It looks as if only
one document is open. This is very annoying as I am unable to close a
certain worksheet from the taskbar.
On Fri, 9 Jan 2004 08:55:47 +0200, "Leon" <firstname.lastname@example.org> - in a
blinding flash of brilliance - wrote:
>When I open an excel worksheet it displays in the taskbar but when I open
>subsequent sheets they are not displayed in the taskbar.It looks as if only
>one document is open. This is very ...How to Export "Empty Tables" +queries+forms+macros for new data base ?
OK, we have our Access multiple table data base designed... sorta.
The test data base was populated with fake data.
How do we export "empty tables" along with all the queries, forms,
macro's, code, etc... so we have the data base structure with no data?
If we can get here we can then import the correct beginning data into
the main table and start using the data base.
thanks for any help.
Take a look at the TransferDatabase method: one of the parameters is
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
"...opening SDI from dialog?
I have problem with opening SDI window from
dialog based application (MFC). What I did I added doc/view
files to project but have no idea how to call this to open window.
I assume that it's safe and possible.
In regular SDI application the call is made by this code:
pDocTemplate = new CSingleDocTemplate(
RUNTIME_CLASS(CMainFrame), // main SDI frame window
mApp.m_pMa...Add new record to master and subform at the same time.
Using Access 2003 SP2.
I have a master form and linked subform. For procedural reasons related to
another form, I need to ensure that a new record is added to the subform when
a new record is created in the master form. Obviously, I'm having an issue.
Setup: The forms are locked down. The user must click an custom Add button
to add a new record in the master form. I'm trying to fit the additional code
into this routine. The user can also click another Add button to manually add
a record into the subform, but I also need to do this automatically.
What is the best way to accomplish...New Website Comparing POS Integration Solutions
We recently launched a new Website (http://
poswebstoreintegrations.com) that compares various POS Webstore
integration and eCommerce solutions. We hope that the site can provide
new insight into these solutions.
In our first post, we compared Nitrosell with Kosmos Central. Please
provide any feedback on our comparison. If you want to provide some
additional comparisons between the two, or with a new solution, please
feel free to do so.
POS Webstore Integrations Staff
On Jul 8, 4:29=A0pm, POS Webstore Integrations
> He...excel opens but the workbook doesnt
when i open an excel file, excel opens but doesnt display the file- have to drop and drag file in from elsewhere; tried re-installing excel, then windows but hasnt made difference; any thoughts?
Most likely fix for this problem is from within Excel:
Tools > Options > General
Uncheck "Ignore other Applications"
Close Excel and try again
If this doesn't work try to re-register Excel in the Registry using the
On the Windows Taskbar
Start > Run
Type the following exactly including the space between exe and /
excel.exe ...Spreadsheet Formatting
I am having trouble with shared workbooks and their formatting. Th
many users who access these workbook and enter data all work i
different offices in differenct cities. The files are stored on
shared drive so that everyone can access and work on their assigne
The problem we are having is that after spending a long time formattin
the worksheets to look and print the way we would like them, each time
new user opens a workbook, the formatting has all changed. (Headers an
Footers disappear, isn't set to landscape anymore, etc.)
Why is this happening? Is there a way to keep the...Weekly Time Sheet Consolidate
I am having a problem with time sheet reporting. We have a weekly timesheet
which hourly employees complete every week. Most have been saving EACH
timesheet. That is 52 timesheet tabs.
What I am trying to accomplish is this:
Use the time sheet, and have the TOTALS of each column transfer to a single
worksheet. Example of columns in weekly timesheet:
DAte Day of Week Reg OT Sick Vac Total Hours Lunch
The date column is filled with date beginning on a Sunday, ending Saturday.
There are formulas to calculate the total hours.
...Opening email messages
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
When I double click on the message, it does not open. I have to right click on the message and click on open message to open my emails. I have already gone into preferences and clicked on double click to open. <br><br>What am I doing wrong?
On 1/16/10 3:58 PM, in article 59bb114f.-1@webcrossing.JaKIaxP2ac0,
"Betsy_Allen@officeformac.com" <Betsy_Allen@officeformac.com> wrote:
> When I double click on the message, it does not open. I have to right click