Excel 2003 :: Right Click Not Working In Sheets

Aug 8, 2014

By chance I have opened a sheet with some macro and after that 'right click' is not working in any of the excel sheets (even newly created ones) in sheet names tab.

i.e., I can't delete/rename/insert etc in any sheet by rightclicking the sheet name.

Even the Edit->'delete sheet' is disabled. However, Insert->worksheet is enabled.

How to make the right click enabled. (excel version 2003)

View 5 Replies


ADVERTISEMENT

Macros That Were Working In Excel 2003 Are Not Working In 2007

Jan 25, 2010

I have a workbook in excel 2003 which I had been running the following macros (listed below). We recently upgraded to Excel 07, and neither are working. When I try to run them, the "debug" option highlights the following line in the sort macro "Range("A2:z" & lastcell).Sort key1:=.Columns(1)". This is driving me crazy, as the macros worked perfectly under the older version of Microsoft. Is there an issue with crossfunctionality between '03 and '07'.

Private Sub Worksheet_change(ByVal target As Excel.Range)
If target.Column = 1 Then
ThisRow = target.Row
startRow = 1
i = 1
Set ws = ActiveSheet
maxRow = Cells.SpecialCells(xlLastCell).Row
maxCol = Cells.SpecialCells(xlLastCell).Column
ActiveSheet.UsedRange.Interior.ColorIndex = xlNone
Do While i

View 9 Replies View Related

Excel 2003 :: For Every Button Click - Run Few Set Of Statements?

Feb 26, 2014

I have button on the first tab in excel 2003. On every click of button, I need to loop the data.

View 4 Replies View Related

Excel 2003 :: Alt + F11 Key Not Working?

Feb 21, 2012

when I use the above key stoke nothing happens in excel. It won't get me into vba editor??

using Dell laptopInspiron N4010 and office 2003

View 2 Replies View Related

Excel 2003 :: Double Click Event On Form Title Bar?

Dec 10, 2012

I am using excel 2003. I would like to double click on the form title bar to shrink the form to only show title bar. Double click again will restore the original size.

View 8 Replies View Related

Excel 2003 :: Undo Is Not Working

Nov 12, 2013

why my undo just won't ever work. Excel 2003.

View 1 Replies View Related

Excel 2003 :: Auto Filter Stopped Working?

Sep 12, 2013

I've got a spread sheet at work that is shared between 4 people. It's password protected and its been protected so only four of us can edit it. It was working fine until yesterday for no reason the auto filter stopped working. The drop down arrows are still there but nothing happens when you click on them?

The sheet was made on excel 2003 but one of the users uses the newer excel which we will all eventually get.

View 2 Replies View Related

Excel 2003 :: Border Line Styles Not Working

May 20, 2012

(Excel 2003, using Format/Cells)

I have selected a range of multiple rows and columns. I can change the alignment, cell color, where border lines appear, and the color of border lines.

However, I can not change the border line style. No matter what style I select, when drawn on the sheet it apppear as a thin solid line. I've tried all the dashed/dotted line options, but they appear to have no effect.

Ultimately, I want to color alternating rows of cells, and (since coloring hides grid lines) I want to add border lines the same color and style as the hidden grid lines.

View 2 Replies View Related

Excel 2003 :: What Date Will Be 45 Working Days After Today

May 20, 2012

I need a function to work out what the date will be 45 WORKING days after today(), this function needs to exclude Saturdays, Sundays and any Public Holidays i.e. there could be either 10 or 12 weekend days added into the calculation depending on when today() is plus any additional Public Holidays.

I am using Excel 2003 although it will need to work in Excel 2010 shortly.

View 4 Replies View Related

Excel 2003 :: Conditional Formatting Not Working And Cannot Change Colour Of A Cell Or Writing?

Sep 23, 2013

Excel 2003

On one of our computers at work, Excel is acting especially strange. The conditional formatting in Excel on one of our computers is not working. In addition, we cannot fill a cell with any color or change the color of the writing. We can click a color for the letters and type it in, but immediately after another cell is highlighted, the writing goes black again. When we try to highlight multiple cells with the cursor, the cells are black instead of the normal color. This happens to not just spreadsheets that are new, but existing spreadsheets on our shared drive from only this one computer as well. No other computers are affected this way. All other computers show the spreadsheets fine and do not have any functionality issues.

View 5 Replies View Related

Excel 2003 :: Average Of Values Across 5 Sheets With Two Criteria

Jun 12, 2014

I have a couple of issues and if its okay will post two threads to make it easier to follow due to my basic skills in Excel.

I have a workbook with 5 sheets. The first sheet is a stat sheet which picks up data from four other spreadsheets. I want to work out the average working days taken to complete a case but this data is across multiple sheets.

So for example Column E in each sheet tells you what type of case it is i.e. investigation. Then column T tells you number of workings day it took to complete the case. To work this out I have used the following formula:

=SUM(SUMIF(Further_Action!E:E,"Investigation",Further_Action!T:T),
SUMIF(Court_Application!E:E,"Investigation",Court_Application!T:T),
SUMIF(No_Further_Action!E:E,"Investigation",No_Further_Action!T:T),
SUMIF(Closed!E:E,"Investigation",Closed!T:T))/SUM(COUNTIF(Further_Action!E:E,"Investigation"),
COUNTIF(Court_Application!E:E,"Investigation"),COUNTIF(No_Further_Action!E:E,"Investigation"),
COUNTIF(Closed!E:E,"Investigation"))

I know its very basic but its the only way I know how to work out an average in Excel 2003. I need to add a second criteria where on every sheet it looks in column G for date the case was allocated. As I'm only looking to report in the current report year I want it to look for cases where the value in column G is =>01/04/14 but =<31/03/14.

View 2 Replies View Related

Excel 2003 :: Pull Data From Multiple Sheets?

Mar 20, 2014

So I am trying to pull data from multiple sheets. I've gone through the thread, but haven't found an answer yet (or didn't work hard enough). On Sheet1, yellow highlighted column, I am trying to look up the I.D. Code for 36 month residuals. As you can see, I have to use multiple conditions on different worksheets.

I have to use most of Sheet1 columns to find the answer. I just can't figure the formula out.

I don't have Excel 2007, only 2003 I have.

View 1 Replies View Related

Excel 2003 :: Identify All Sheets Related To One Sheet

Oct 13, 2011

I have been given an excel model to review;the workbook has 53 sheets. I would like to know if there is a way to create a flowchart/matrix with the relation of all the sheets. I would like at least to get a list of all the sheets related to each sheet. All what I was able to do is to get all the sheet names in one sheet. (I am using Excel 2003).

View 2 Replies View Related

Excel 2003 :: Macro To Hide Multiple Sheets?

May 10, 2012

I wrote a macro to select multiple sheets by name and hide them, but I keep getting the following error message:

"Object variable or with block variable not set".

Below is the macro:

Sub HideSheets1A()
Dim ws As Worksheet
Application.DisplayAlerts = False
If ws.Name = "Variance Evaluation" Or "Investment" Or "Costs & Incentives" Or "Revenues Total" Then ws.Visible = False
End Sub

I use Excel 2003

View 5 Replies View Related

Excel 2003 :: Unprotect And Protect Multiple Works Sheets With Macro?

Feb 25, 2008

I have an annual leave (vacation) work book with a summary page work sheet and separate work sheets for each month i.e. Jan, Feb, Mar.....to......Dec. In order to protect the formulas I have protected them by allowing only access to the input cells on each work sheet and the protect each work sheet.

When someone either joins or leaves the team I have to manually unprotect each sheet and protect again when I have completed the amendments to each of the 13 tabs.

macro code I would need to unprotect all the works sheets in one go (as I use the same password for all the sheets) and reset the passwords (protect) the sheets with more macro code.

I will be running the two macros from my own personal.xls file and ideally they would be fully automatic i.e. I would not need to input the passwords in to unlock or lock the work sheets as the password would be written in the code already

Excel version 2003

View 3 Replies View Related

Excel 2003 :: Averaging Cells In Multiple Sheets And Not Including Null Or Zero Value?

Jun 24, 2012

I need to calculate the average spend on a day of the week over the month, so all Monday's or all Tuesday's, etc. One sheet is one week so I need to average b16 on 6 sheets as an example.

I used =AVERAGE('WEEK1:WEEK6'!B18) to calculate average over the six Monday's. The issue is, as in other posts, how do I ignore the cells that have a zero or null value.

I've tried adjusting this which was in 1 post
=AVERAGE(IF($C$2:$CA$2=C62,IF($C$25:$CA$25"",$C$25:$CA$25
with this
=AVERAGE(IF(1+1=2,IF('WEEK1:WEEK6 '!B180,'WEEK1:WEEK6 '!B18))) which returns #REF!

this from another post
=SUM('WEEK1:WEEK7 '!B18)/COUNTIF('WEEK1:WEEK7 '!B18,"0") which returns #VALUE!

and this
=AVERAGE(IF('WEEK1:WEEK7 '!B180,'WEEK1:WEEK7 '!B18)) which returns #NAME?

The cells on each sheet are sum formulas for other cells on the sheet not just numbers on their own.

Using windows 7, excel 2003

View 3 Replies View Related

Excel 2003 :: Getting 1004 Error While Copying Data From Sheets To Master Tab In The Workbook

Mar 12, 2014

I have attached a workbook (excel 2003), I have few userforms in it.

I tried to copy data from all the tabs in the workbook to "Master" tab but getting an error.

You have to login to file details are as below:

View 3 Replies View Related

Excel 2003 :: Formula For Counting Values Across A Range Using Multiple Criteria Across Multiple Sheets

Feb 9, 2014

I have saved this on a 2010 workbook as I am at home but this will be used on a 2003 workbook.

I have several projects on one spreadsheet which multiple users will be working and I am trying to create a summary sheet of the work carried out.

Each user is expected to carry out a task on each row of the data held in each worksheet (research, call, update etc) and each task (Option 1-5) is assigned a value. Each user is expected to meet a certain level of points per day to calculate productivity.

I am looking for a sumproduct along the lines of the summary sheet attached but mine just takes one sheet into consideration and I need one for all sheets.

View 12 Replies View Related

ListBox Click Event Not Working

Feb 14, 2013

I currently have a set of ListBox controls on a worksheet tab. They are all configured as multi-select and i have the values populated via the ListFillRange properties. Each listbox has an '{All}' option; when the user clicks on this value I want to de-select all other previously selected values. The code for this is straightforward enough, but I cannot get it to fire using the _Click event. Why this is not working?

Additionally, I attempted to use the _Change event but quickly got caught in recursive loops which obviously is not going to cut it.

View 9 Replies View Related

Mouse Macro (right Click Not Working)

Mar 12, 2008

my right mouse-clicker doesn't work in excel anymore. something with macros happened I guess.

has anybody an idea to activate it again?? it's just in the workfield, to change worksheets-colours and stuff at the worksheet-registry it works as usual.

it's very nasty to work in cells without mouse..

View 9 Replies View Related

Double Click Cell To Go To Source Not Working?

Nov 28, 2012

Normally when I double click on a cell with a formula linked to another spreadsheet, the double click takes you to the source. However, if the cell also has a comment, the double click takes you into the edit comment option and not to the source.

Is it possible to turn off the edit comment option from the double click?

View 5 Replies View Related

Enter Button Not Working In 2003?

Apr 24, 2009

When you hit the enter button, it should jump to the cell below the one you currently have selected. Well, mine doesn't do that anymore? My tab works fine to go to the cell to the left, but enter just keeps the current cell selected. I know it isn't the Keyboard, b/c it works for every other app. What have I disabled/enabled to cause this? This happens with both the "return" enter button and the enter on the number pad. As of right now, either a mouse click or the down arrow is the only way for me to jump to the next cell.

View 3 Replies View Related

Macro In 2003 Is Not Working In 2000

Apr 25, 2008

I have constructed a macro, (with lots of help from the fine people on this site), and have distributed it to several people in the company. The macro was written in Excel 2003, and runs perfectly on all the machines running Excel 2003, but persons using Excel 2000 are getting a runtime error, variable not defined.

Is there a trick to getting a macro to run in both versions of Excel?

View 9 Replies View Related

Cut / Copy / Format Painter Stopped Working (Don't Have Skype Click To Call)

Aug 23, 2013

When I copy or cut, I usually get a dashed border around the cells I have copied (or cut), I can then right-click somewhere to paste, but at some point in time recently this functionality has stopped working. The format painter doesn't work either - the paintbrush icon stays pressed for about half a second, then just goes away and I can't paste my formatting.

An operation I often do in excel is to copy a date from one cell, then highlight a few cells elsewhere and press enter to paste the date into them. I also like to right click on a row and Cut, then past it further down my list to re-order things, but this won't work either.

I don't know what I've done to make it go away. If I restart my computer and open a workbook, then I can copy/paste at least once (maybe a few times) then it stops again.

This is caused by a Skype 'click to call' function, but I don't have that installed here. I have actually just tried installing it, so I could run through the uninstall (thinking there might be debris from something previously), but it made no difference.

View 2 Replies View Related

Apply Double Click Event To All Sheets

Jul 16, 2014

I am trying to apply a double click event to all sheets. It works if I apply to each sheet but I won't to prevent from having to copy and paste into each new sheet. I am trying this code in ThisWorkbook but doesn't seem to work.

VB:

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
' If the cell is clear
If Sh.Target.Interior.ColorIndex = xlNone Or Sh.Target.Interior.Color <> vbCyan Then
' Then change the background color to yellow
Sh.Target.Interior.Color = vbCyan

[Code]....

View 3 Replies View Related

Cannot View Sheets In 2003

Aug 11, 2008

I am using some protected workbooks and cannot see the tabs at the bottom of the screen.

I have tried going to tools/options/etc

I have tried viewing full screen

If I copy the current sheet 1 and paste it into a new workbook I can then see tabs (but only sheet 1 has copied data).

View 14 Replies View Related

Printing Scattered Ranges In Different Work Sheets By One Click

Apr 9, 2007

I have four sheets workbook, and i'd like to set a command button that prints scattered tables ( ranges) on my workbook but still have a pattern.

I attached a simple wokbook that explains how ranges are positioned in my workbook, i hope that it is possible to print these tables in the sequence shown in the file by a single command.

View 5 Replies View Related

Before Double Click Event Procedure For Multiple Sheets

Apr 2, 2008

I have a calendar userform set as Userform1 and I would like it to pop up upon double clicking in two different ranges 'date' which is on sheet 1 and 'dates' which is on sheet 4.

So far I have this code in Thisworkbook, which works perfectly for Sheet 1, but I get the following error on Sheet 4: Run time error '1004': Methed 'intersect of object'_global' failed.

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
If Intersect(Target, Sheet1.Range("date")) Is Nothing Then Exit Sub
UserForm1.Show
Exit Sub
If Intersect(taregt, Sheet4.Range("date2")) Is Nothing Then Exit Sub
UserForm1.Show .............................

View 9 Replies View Related

Raw Data Transfer Between Sheets, 2003, Windows XP Pro

May 31, 2007

Where I work there is a file that we have to submit to management every Friday. This is a raw data file to be imported into another system. With 7 different employees accessing the same passworded file on a network drive, we have had some errors in the external program due to input typos.

I have created a worksheet for employees to input weekly data, ie workorder number, hours worked, etc. all in a neat and defined order. I have also added nested if formulas to validate data length and duplication within a group.

Now I need to transfer just the raw data from the employee entry sheet to a seperate sheet, reformated in the raw data format. This requires copying common data for all workorders worked. I can provide more data examples from work.

I would prefer that the data copy and reformat be done with formulas as the parent company frowns on excl macro's, especially unsigned.

I have 15 rows available to the employee each day to input. One of the problems I have ran across is the raw data format cannot have blank rows or rows with missing data.

View 14 Replies View Related

Working With Multiple Sheets?

Jun 21, 2013

I have a workbook which has multiple sheets all with the same format.

When I make a change in one sheet it seems to impact another. There cells are not referenced. I have selected all sheets and selected ungroup.

I need to update numbers on individual sheets, i get about 40% done and when I look back all the numbers are now different.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved