Opening Excel Opens Too Many Sheets
Don't know what I did recently but when I open Excel, FINANCIAL MANAGER is
added to the main menu at the top and several sheets/files are opened that I
do not want to open. FINANCIAL MANAGER wasn't there before and I can find no
way to take it off the menu. I find no "startup" folder that lists these
files that I could delete the shortcuts to - I've looked in the various
folders relating to Excel but not found anything that might stop this
activity whenever I open Excel.
Opening the shortcut I'd been using to get to Excel, it's like a macro
starts off and I fin...Checking for duplication on rows
In a particular spreadsheet, I would like to verify if the same name is
listed on multiple rows. The name is entered in multiple columns on the
same row, that is acceptable, but I would like to know if the name is
entered on multiple rows regardless of the column. How can I check
Karmen's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30972
View this thread: http://www.excelforum.com/showthread.php?threadid=509495
Presume you're checking some...sheet protection #7
why can't i protect some of my excel sheets?
Is the workbook shared?
Have you grouped multiple worksheets?
> why can't i protect some of my excel sheets?
...How to check continuous form fields
I have a tabbed form, when I switch from one tab to another, it checks to
make sure that none of the mandatory fields are missing. However the code
that checks the records on tab #1 (which is the code below after the elseif),
the code only checks the first record. I can not figure out how to modify
the code to get it to look at other records on the form that may be present.
Any suggestions on what modification I would need to make here would be
If TabCtl4 = 1 Then
Dim CkCtls As New Collection
...I can't select cells on Excel using the touch pad, and neither the sheet not the workbook is protected
Operating System: Mac OS X 10.5 (Leopard)
SOS folks, <br><br>I am in a pickle! So, as I was working on Excel, something happened because now it doesn't let me select cells with the touchpad, but only using the arrow keys. It's very strange. I went to tools to make sure that neither the sheet nor the book is protected...What can it possibly be? <br>
I would be fantastic if somebody could cast some light on this technical glitch. <br><br>All the best, <br><br>Joseph
Hail mates, I solved the problem by updating the software...Check to see if a formula is correct
I want to do something like this
If Range("A1") =(=B1 + B2) Then ' This is a formula
Range("C1").Select 'Has correct formula
How do I do this?
If Range("A1").HasFormula Then
Application.CutCopyMode = False
...Problem With Deferral Check Links
When i Do Deferral Check Links in File Maintenance. I am
getting an error message "A remove range operation on
table 'PP_File_Maintenance_Error_Log' cannot find the
On clicking the more Info button. These messages are
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not
find stored procedure 'TEST.dbo.zDP_PP400004L_1'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
object name 'TEST.dbo.PP400004'.
In the database these two objects are not present. Can You
Pl. tell me what to do about it.
These do not...Unable to password-protect "VeryHidden" worksheet
I'm using Excel 2007. In VBE I tried to password-protect a "VeryHidden"
worksheet by going to VBAProject Properties, Protection, check the box on
"Lock project for viewing" and set the password in the boxes as provided.
However, each time I re-open the file (after saving and closing the file),
the worksheet was not protected. When I check the VBAProject Properties, the
check box of "Lock project for viewing" and the "Password to view project
properties" are all back to its original state of unchecked/empty.
Please advise what steps I...How do I update links from .xls sheets to .xlms sheets
I have thousands of links to many consolidated spreadsheets created in Excel
2003. Now that I use Excel 2007, how do I convert the links without breaking
On Apr 21, 2:06=A0pm, June <J...@discussions.microsoft.com> wrote:
> I have thousands of links to many consolidated spreadsheets created in Ex=
> 2003. =A0Now that I use Excel 2007, how do I convert the links without br=
After making a copy of your workbook, try to search and replace ".xls"
Hope this helps,
It's not clear what you'v...Time sheet issues
There are three questions
I am preparing a time shhet.
To strart with I have to prepare a blank sheet and give one sheet for each
Here are the blank walls I am hitting
1. I want to format a cell (E2 in my time sheet) in such a way that if
enter "1" it should display "January" and so on. How to do it?
2. The First cell of last row (A 34 in my of the time sheet) should have 28,
29, 30 or 31 depending the conditions of E2 and H2 which has month and year
3. The cells B4 to B34 should have days cooresponding to dates (number) in
A4 to B34
They sho...Sheets not getting displayed
When an excel file is opened the sheets are not getting displayed. Using
windows XP. Pls help how to overcome this situation
Are the sheets hidden? - - try Format, Sheets, Unhide, and unhide any
required sheets listed there.
Saj Francis Wrote:
> When an excel file is opened the sheets are not getting displayed.
> windows XP. Pls help how to overcome this situation
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread:...last sheet or go back
I have been trying to figure out how to go back to the last sheet that
I was working on. I often navigate my spreadsheets with hyperlinks,
but I haven't figured out how to go back to the sheet I was last on.
Any help would be great.
By the way, what is up with all of these weird posts that we have been
inundated with lately?
> By the way, what is up with all of these weird posts that we have been
> inundated with lately?
Some nutter sends them out now and then - probably trying to get into
the top-10 posters lists !!
How about a navigation bar from Debr...Check out http://hackityourself.com
*Check out http://hackityourself.com*
They hack email and myspace accounts for like $50, i used um before.
Looks like their price even went down a few bucks.
...Error occurred while loading sheet 3011111111111111111111111111111
I get this message on one of my XL workbooks - fairly sure it's
converted from XL 97. I've read all the related posts which all say
that the answer is to open the file in XL 97 and do the fix. All well
and good but we no longer have XL 97 - is there any other way to fix
the issue and open the file?
If you can't open the file in 2000-2003 then send me the file and i will
change the codename for you.
Send the file to me private
Regards Ron de Bruin
"FMR" <firstname.lastname@example.org> wrote in message news:c5c9f293.04080...transporting repetitive data from another sheet
How do I transport data from another sheet in a repetitive order?
In Column A I would like to transport data from sheet 3, however the data in
sheet 3 skips every 4th line (row 4, 8, 12, 16, etc.).
I have the formula ='Sheet3'!$E4
The next row should have ='Sheet3'!$E8
When I highlight a series of these cells (all typed correctly and skipping
by 4's) and drag the fill tool down (cross hair at bottom right of cell) it
does not fill properly.
Do not alter the A1 - this just gets serial numbers 1,2...Spell Check in Outlook Express
Running a nDell Dimension 2400. When I spell check e-
mail in OE I get,"An error occurred whiole the spelling
was being checked.". When I set the option to always
spell check before send, I get the message, "The spell
check on the document was halted. Do you want to send
Can someone solve this for me. I will be grateful.
This newsgroup is for support of Outlook 97, 98, 2000 & 2002 from the Office
family for Windows PCs. For Outlook Express (OE) support try posting in one
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
m...P/R adjustments after Calculate Checks
After Transactions>>Payroll>>Calculate Checks, is there an "easy" way to
change/adjust the deduction amounts (ie: Federal W/H) prior to printing the
We are trying to do a parallel (catch-up) P/R run and changing the amounts
prior to posting.
Or.. should we post then use the Payroll Manual Check - Adjustment, to
change it after posting.
There is no way to update the information after you calculate paychecks
unless you remove the build; make the adjustments; and rebuild/calculate. If
you needed to determine a garnishment amount, for example, th...Checking on two values
To count the numbers of rows that include the number "16" in column "I", I
use the following formula:
(I think this is called COUNT.IF in english)
I want to count the numbers of rows that include both this and the letter
"A" in column "B". (Meaning not counting rows which just fulfill one of these
How do I write this formula? (Please feel free to write the english formula,
I will find out how to write it in norwegian.)
COUNTIF takes only one criteria. You can do this wit...Protecting certain cells
I am using formulas to get averages , standard deviation and other
figurers... I want to be able to lock the cell so others cannot change my
formula but be able to change certain values to get averages and other
I was trying to use the protection under tools to no hope...
any help would be appreciated
In Excel, cells are either locked or unlocked; the default is locked. If a worksheet
is not protected, there is no difference in behavior, but if you protect the
worksheet, the locked cells are protected, but the unlocked cells can be edited.
What you need to d...How do I unprotect a protected worksheet that has passwrod protect
I need to unprotect a protected sheet but it has password protection on it
and I do not have the password, can anybody help?
record a macro and paste the text below into it:-
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: F...Converting a PDF of an Excel sheet back to Excel?
I have just been asked by my boss if it is possible to
convert a PDF of an excel worksheet back into excel!I have
no idea if it is possible, can anyone please help in this
You should be able to copy and paste the values, but you definitely will lose
On Thu, 23 Sep 2004 17:31:48 -0700, "Ashley"
>I have just been asked by my boss if it is possible to
>convert a PDF of an excel worksheet back into excel!I have
>no idea if it is possible, can anyone pl...How can I password protect a folder?
File--> Save As
Tools--> General Options
"NSharp" <NSharp@discussions.microsoft.com> wrote in message
Windows XP, like other sophisticated operating systems, does not provide
permissions this way. Permissions are based on users and user groups.
In XP Pro, make a new user group and call it something useful
("Sekrit") and assign users to that group. Don't forget to assign
yourself! Then set permissions on the resource (folder) only allow
members of the Sekrit group read/write or whate...check register template #2
at the top of the template a range of cells says stationary and if you look
at it in print preview it stays on top of all other applications......does
anyone know how this works???? how about you JulieD
you mean how does row 4 & 5 get repeated on each page that you print out?
if so, file / page setup - sheet tab, rows to repeat at top.
"Michele" <Michele@discussions.microsoft.com> wrote in message
> at the top of the template a range of cells says stationary and if you
> loo...I need a four sided program to print on one sheet
I need to make a four sided program, front & back to print on 8.5 x 11 sheet
Okay - so what's your question?
MVP Microsoft [Publisher]
"debbie hughes" <debbie email@example.com> wrote in message
>I need to make a four sided program, front & back to print on 8.5 x 11
debbie hughes wrote:
> I need to make a four sided program,
> front & back to print on 8.5 x 11 sheet
Choose one of the pre-formatted greeting
ca...Check in vba if html document is already open.
I have a vba macro that opens an html document in IE. I want to be able
have the macro check if the document is already open or not; if it is then I
want to switch the focus to it rather than open another instance How can I
achieve this? It is not sufficient to check if IE is running as the user
may have other websites open at the time.