File Getting Too Big Because Of Arrows Not Being Deleted

Oct 3, 2013

I do a weekly report for my employer. We have our tabs conditionally formatted. We then insert the corresponding arrows to show a trend to the weekly variance. After the week is up I will delete a column and add a column to the end (making it a trended view) and move the arrows by selecting and dragging all of them into its respected week. I then go on to delete several arrows throughout the worksheet. For some reason my file continues to grow in size however I am only keeping a 12 week trend. The arrows are not deleting properly and are sitting in the background, where I cannot see them. I know this bc I did "find & Select" and chose selection pane. I was wondering how I can resolve this problem or maybe delete just certain columns of arrows (objects)? I had 61,000 arrows and shouldn't have more than a couple 1,000.

View 5 Replies


ADVERTISEMENT

Protecting File From Being Deleted

May 3, 2006

Is there a way to protect an excel file from accidently being deleted. I have a shared workbook, and I am concerned it might be deleted from the folder.

View 2 Replies View Related

Recover Deleted File

Jul 5, 2006

How can I recover a file I deleted? I looked in the Recycle Bin and do not see it.

View 2 Replies View Related

Stop File Being Deleted

Oct 16, 2007

I have an Excel workbook that I do not want deleted. Is there any VBA code I can do to the document to stop this from happening? which Ic ould turn on/off?

View 4 Replies View Related

Restore Excel File After Deleted?

May 26, 2014

i accidentaly deleted excel file how can is recovery it

View 2 Replies View Related

Password Protection :: Asking For Password Of An Old Deleted File

May 27, 2009

When opening a new Excel file, it is asking me for a password to an old excel file that was password protected, which I have deleted from my computer. It is still asking for this password every time I open a new or existing file. When I hit cancel it lets me open the file.

View 11 Replies View Related

Macro Runs Fast When Rows Added / Deleted Slow When No Rows Added / Deleted

Jun 27, 2013

We have created a macro that basically looks for rows that contain an "H" and hides the row if it does.

Users can add new rows throughtout the year to this spreadsheet. and based on certain criteria, an H or U will be placed in a hidden column which the macro looks at and hides any row it finds an H.

The user has to click on the button that has the macro assigned to it once they have finished working on the spreadsheet.

The problem we're finding is that for users who insert/delete rows, once they click the button it takes up to 15 seconds to run through macro (which is ok). However, users who haven't added or deleted any rows and who click the button, they have to wait upto 5 minutes (which isn't ok) for the macro ro run.

We can't figure out why the macro takes longer to run when no changes have been made?

View 8 Replies View Related

Pivots - No Drop Down Arrows

Jun 8, 2007

I have been sent a spreadsheet with data in it that is from a Pivot table.

The headings look like the ones in the Pivot table the only difference is
there are no drop down arrows to show/hide items

I cant click and drag fields to swap them.

So it looks like a Pivot but I cant manipulate it.

View 9 Replies View Related

Trend Analysis With Up/Down Arrows

Oct 5, 2006

I need to analyse trends between a range of cells. The idea is to display an image of a triangle pointing up if the percentage between the current month and the previous is bigger, a triangle pointing down if the percentage has decreased or a rectangle if both months are the same. I've tried to build a userform to ask the user to input the range and then analyze the data...with no luck at all.

View 9 Replies View Related

VBA Code For Resizing Arrows To Specified Length?

Jun 7, 2013

I have created this Excel schedule that is attached. The point of the schedule is to organize Jobs and Crew members. I have VBA code in, so when I calculate how long the job should take, the arrows next to the job will automatically extend. (This should all make sense if you take a look at the attachment.) The only problem is that my arrows do not extend the correct distance. In the attached file I have scheduled "James Lorenz" to do a job starting on tuesday, towards the bottom of the page I did my calculation that figures he should be on that job for 9.5 days. I would like the Arrow next to James' job to extend 9.5 days on the calender instead of 9.5 centimeters or whatever it is doing now.

View 9 Replies View Related

VBA Autoshape Arrows To Show Performance

Oct 2, 2008

Morning all. I'm trying to use VBA to generate autoshape arrows to track changes in values.

Something allong the lines of Column B (Jans data) C (Febs Data) E (autoshape arrow, green up, for improvement, or red downwards for a worsening).

The problem I'm having is postioning my autoshapes. The only way I can do it at present is to keep all columns and rows a standard width, and position using multiples of those.

Is there anyway to set the autoshape to the cell height and width, and position it within the boundries of the cell? This way I don't have to worry about rewiting my code every time I change a cell width?

View 7 Replies View Related

Validation Lists And Drop Down Arrows

Aug 26, 2006

From the Excel Toolbar - Data/Validation - I'm successfully using a validation list [drop down arrow] to be able to choose from a list and have whatever value I choose entered into the cell. So far so good. Everything working fine.

Here's the thing though, the list I'm referencing is a column with 50 rows. Sometimes there are many items in the column - up to 50, and sometimes only 3 items depending on other variables in the spreadsheet.

Because the list is referencing the entire 50 rows in the column (only way I know how to do it), during times when the column has only 3 items (3 rows), the drop down still shows a bunch of blank spaces (like 47 of them - tons of white space with a scroll bar window that runs down beyond where one can see), which is awkward (strange looking).

How do I program the validation list to only show as many cells within a range that have actual values within the cell, or where <> "" ? Or, in other words, to leave all blank spaces found in the list = NOT SHOWN.

View 9 Replies View Related

Removing Arrows In Filtered Table?

May 25, 2014

I have a table A-AP 4-499 (row 4 being the column headers and 5 being the first row of data).

I'd like to remove some of the filter drop-down arrows as they aren't needed for some column headers and they also look unsightly.

This code works to remove all of the arrows:

Sub HideArrows()
Dim c As Range
Dim i As Integer
i = Cells(1, 1).End(xlToRight).Column
Application.ScreenUpdating = False
For Each c In Range(Cells(1, 1), Cells(1, i))
c.AutoFilter Field:=c.Column, visibledropdown:=False
Next
Application.ScreenUpdating = True
End Sub

However, I want to only remove arrows in the following column headers: A, G, I, J, K, M, N, O, P. I want to keep the rest.

View 3 Replies View Related

VB Code For Hiding Autofilter Arrows

Jul 25, 2008

I found this code for hiding an autofilter arrow for column 2. I would also like to hide the arrows for columns 35 through 50. Does anybody know how to do that? Thanks.

Private Sub Workbook_Open()
'hides all arrows except column 2
Dim c As Range
Dim i As Integer
i = Cells(1, 1).End(xlToRight).Column
Application.ScreenUpdating = False
For Each c In Range(Cells(1, 1), Cells(1, i))
If c.Column 25 Then
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False
End If
Next
Application.ScreenUpdating = True
End Sub

View 9 Replies View Related

How To Remove Filter On Table Without Removing Little Arrows

Mar 17, 2014

Tables and filters. I was using the following code to check for filters on a sheet of data and then show all data.

[Code]....

View 2 Replies View Related

How To Make Different Colour Arrows Appear Based On Set Criteria

Jul 24, 2014

I am trying to make different colour arrows appear based on a set criteria, I am having issues with the hide/show amber part, it doesn't seem to be doing the "AND" part.

'Hide/Shows Green'
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A1").Value >= 0 Then
ActiveSheet.Shapes("Arrow1").Visible = False
Else
ActiveSheet.Shapes("Arrow1").Visible = True
End If
'Hide/show Red'
If Range("A1").Value = 0 And Range("A1").Value

View 5 Replies View Related

Odd One, Up And Down Arrows Stop Working When Sheet Protected

Jan 10, 2008

The sheet was working fine, then all of a sudden (i dont know what i have done) the up and down arrows (on my kayboard) wont work when the sheet is protected, when i unprotect the sheet they work fine, i can use left and right. i have checked the scroll lock isnt pressed/illuminated on my keyboard.

View 9 Replies View Related

Creating Arrows Based On Range Values

Sep 22, 2006

I'm trying to create a VBA macro that will compare two worksheets. If an item has "moved" then I want to draw an arrow on the new worksheet of where (the cell range) it was on the previous worksheet, to where it is now. Using Record Macro, I've noticed the coding looks like: ActiveSheet.Shapes.AddLine(276#, 60.75, 309.75, 60.75).Select

How do I make sense of these numerical values? Is there a way to input cell ranges? Is there anything besides drawing arrows I can represent this phyiscally? (as opposed to with values)

View 2 Replies View Related

Change Color Of AutoFilter Drop Arrows

Jan 9, 2008

Is it possible to change those AutoFilter drop-down arrows that are active? As it is now they are hard to spot which is in use.

View 5 Replies View Related

Trend Up / Down Arrows Using Conditional Formatting Icon Sets

May 30, 2014

I am looking to show Month Wise Trend Up/Down/Nuetral Arrows for the Achievement % for each month.

I want to show the Increase or Decrease trend of the % in the next month.

I have Baseline figures (count) and i have count of Mar, Apr, May months. (Column A)

I have calculated the Achievement % by 100%-(Actual/Target) (Column D, G, J for Mar, Apr, May Months)

I want to show the Increase or Decrease Trend Up/Down/Nuetral buttons either by the Achievement % or by the Total Incidents Each month compared to the Baseline Figures (Column A).

I tried to use Icons Set in Conditional Formatting but i was not able to do that.

Sample file attached : Sample.xlsx

View 2 Replies View Related

Excel 2007 :: Conditional Format Using 3 Arrows Coloured?

Sep 24, 2012

I'm attempting something that I feel should be relatively easy using the conditional formatting icon sets (3 arrows coloured)

I have values in columns A and B. I simply want to compare the value in column B against that in A, and format column B accordingly

B > A (green arrow)
B = A (amber arrow)
B < A (red arrow)

The icon set rules only allow for > or >= conditions, and I can't get the desired results using the rules.

A
B
B (with conditional formatting)

1

10
20
Green arrow (increase)

2

20
20
Amber arrow (no change)

3

15
5
Red arrow (decrease)

4

Excel 2007.

View 5 Replies View Related

Remove Filter Arrows In Some Column Heading Cells?

May 2, 2014

I have a table with a filter applied. I don't want all of the column headers to be filtered because the data in those column is not suitable filter criteria. Is there anyway I can remove the individual arrows on the right hand side of the cells in question?

View 6 Replies View Related

Catch Deleted Row

May 19, 2008

I want to catch if the user has deleted a row. There is a need to know when a row is deleted and what the data was in that row. So, what I'm trying to do if a row is deleted is to undo the action and then change the font of all data in that row to have the strikethrough effect. This will enable others looking at the workbook to know that the information in the row existed but is no longer relevent.

So, the code is something like this:If row deleted Then
Application.Undo
Target.Font.Strikethrough = True
End If

View 9 Replies View Related

A Moveable Text Box That Can't Be Deleted

Apr 8, 2009

I'm not sure what it's called, but in a workbook that was sent to me, when a cell is selected a text box appears with instructions in them. This is not a normal comment and I found that I cannot select it, right click it, or anything to delete them. They can be annoying as they cover up other data when the cell is selected.

View 2 Replies View Related

Keep Command Button After Row Is Deleted?

Jun 12, 2014

how to keep a command button in a certain location even if the a row or Column is Deleted or Inserted into the worksheet?

View 1 Replies View Related

Keep Row Height Of Deleted Row That Shifted?

Jul 16, 2014

I'm using the macro below to delete a row, which works but is there a way to keep the row heights for the row that is shifting up?

[Code] .....

View 9 Replies View Related

Button Don't Get Deleted Completely

Dec 30, 2008

I have a problem regarding buttons.I have placed buttons on my excel sheet with a regular spacing between them.These buttons are placed dynamically on the sheet and I don't know what will be their names as user can add as many as they like.Now the problem is suppose there are two buttons in the range "A1:d8" and say now i delete the this range (using range("A1:d8").entirerow.delete) then buttons do not get completely deleted .A very thin line size button still remains on the sheet.

How to remove the buttons completely......

View 9 Replies View Related

Run Macro When Worksheet Is Deleted

Feb 26, 2009

I have a macro i would like to run whenever a user deletes a worksheet...

I would like the user to be able click as normal to delete,(ie. right clicking the tab and selecting delete worksheet, or selecting delete worksheet from the menu) but would like to run my macro when they select delete.

I am using excel 07 if that helps, or i could use another version...

My macro will save a copy of the deleted worksheet as xlveryhidden as a backup..

View 9 Replies View Related

Track Deleted Row Or Column

Sep 13, 2006

How would I write this in vb. If a row or column deleted in sheet1 insert in sheet2 the date it was deleted, the coloumn or row cell name?

View 9 Replies View Related

Detecting When A Worksheet Is Deleted

Mar 20, 2007

I am working on a workbook in which you can click a button on an index page to create a new sheet in the workbook with the name "meeting" and the number meeting that it is. The new sheet is then added to the index page. I am looking for a way to detect when a sheet is deleted so I can update my index page accordingly. I need to be able to know when a meeting is deleted so I can rename all meetings after that meeting and then update my index.

View 7 Replies View Related







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