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...in VBA
Using Office 2003
I would like to reset any custom filter settings from all columns.
The following resets Column 1 only:
What is the VBA code to reset Columns 1-17?
You could have found that out by yourself if you had just used Macro Record
(as I did).
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Dennis" <firstname.lastname@example.org> wrote in message
news:961i10teu4q5r2t6rh38bmen6lski9r6f6@...Using A Macro/VBA code to re-set formulas
Hi can any one help me with a Macro/VBA code to re-set formulas in
pre-defined set of cells i.e. in my case C14:C40
At present I have a copy of the Formulas in another part of th
worksheet and when I want to reset the worksheet (as the user can ove
right the formulas as the formula is based on either the sum of anothe
two cells or the users input) I use a Macro to copy and paste (special
What I require is a Macro/VBA Code which already has the formula store
in the actual Macro/VBA code i.e. so they are not stored as copy in m
Ay help would be greatly appreciated
T...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?
...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...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...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...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:...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...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...Excel VBA
I have a workbook that has multiple worksheets and 2 of them are letters. I
would like to autofill data into the letters by using the userform. I have
been able to code it using 1 worksheet. Is it possible to use same userform
for the different worksheets?
Very simple, but you need to be more specific if you want some aid.
(replace somewhere in email address with gmail if mailing direct)
"djshides" <firstname.lastname@example.org> wrote in message
> I have a workbook t...VBA moving and adding data
I have this appliaction that spits out a format that is not usable for me,
but with some minor changes it would be good to go. I just don't know how
the code would work.
here is what part of my file looks like:
ColumnA Coulmn B Column C Column D
FAULT F02 8
PILLAR 3018169.273 492458.0997 -9771.365343
3017502.798 493106.6833 -8696.365343
3016836.323 493755.2668 -7621.365343
3016169.848 494403.8503 -6546.365343
3015503.373 495052.4339 -5471.365343
Here is what I would like it to look like:
ColumnA ...VBA calling sp with ANSI_NULLS set ON
On Query Analyzer, I created a sp as follow:
if exists (select * from dbo.sysobjects where id =
object_id(N'dbo.PCS_SEG1') and OBJECTPROPERTY(id, N'IsProcedure')= 1)
DROP PROCEDURE dbo.PCS_SEG1
CREATE PROCEDURE dbo.PCS_SEG1
set ANSI_NULLS on
set ANSI_WARNINGS on
** sql statement ***
I need the to set ANSI_NULLS and ANSI_WARNINGS on as it involves another
server using linked server.
When executing the sp from query analyzer, it works fine too:
But, when I called from VBA, I received error:
Heterogeneous queries require t...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" <email@example.com> 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...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...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 to select combobx value with vba?
For an electrical part number quoting application developed in
Excel 2000, I have a a userform (userform4) with a combobox (cboQpn)
to hold the quoted part number, and another combobox (cboFormula)
prepopulated with a named range (Partnum)
The user types in a part number in cboQpn and then chooses
the correct formula from cboFormula.
Now in access I have a table (tblDetail) that holds previously quoted
and their details--the formula used in the previous quote, for
The formula information is in column 5 in tblDetail
I want to emulate the manual selecting o...VBA help #3
I'm an excel VBA total novice. I dabble in access vba, but am unsure where
to start in excel.
What I need is some code I can tie to a macro (& keyboard shortcut) which
will find all values under 1000 in the selected range and change them to
Can anyone point me in the right direction?
Any help greatly appreciated.....thanks, Jason
Look in the vba help index for FINDNEXT. There is a good example.
Microsoft MVP Excel
"Jay" <firstname.lastname@example.org> wrote in message
news:eYGxqeELIHA.3...VBA Function to explode string
I am wanting to know hbow I would go about getting the following 3
Cells A1, A2, A3:
1-4,6,8 50 S1B1::
Into a form that looks more like this
::A1 A2 A3
1 8.33 S1B1
2 8.33 S1B1
3 8.33 S1B1
4 8.33 S1B1
6 8.33 S1B1
8 8.35 S1B1::
How it does the rounding (and on which one), it does not matter!
tomjermy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24666
View this thread: http://www.excelforum.com/showthread.php?threadid=382414
You haven't exp...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...VBA question confused
I have a form set up with a recordset. I'm also using a filter.
Me.Filter = "position IN ('custody','sgt','lieutenant','captain', 'other')
and shift IN ('a-days','day shift','afternoon shift')"
Me.FilterOn = True
I'm trying to get an order by the last name field. I read Allen Brown's page
about setting the order. I've also read other pages on this board that
basically says it can't be done. So, I wrote an SQL that would give me what I
strSelect = "SELECT * " & _
...escape from vba-loop
I've got an excel-sheet containing some vba-code. There's one sub that
does some calculations in a loop which can run for some time. My users
now want to be able to escape from this calculation by pressing
<escape> or clicking a button on the sheet. But actually excel is
frozen while calculating.
What is the most common way to achieve this? I guess it must be
possible to solve this with excel-events, but I'm not very experienced
in using them.
thanks for any hints,
You can add a "DoEvents" statement inside the loop.
Excel checks for any instruc...