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..
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?
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.
I want to delete a cell row in a table when I delete a corresponding worksheet with the same name as the cell.
For example, on the attached, if I delete the worksheet "Shawn" then I want row with "Shawn" deleted from the table on the "Example" tab. If I delete "Becky" worksheet then the row with "Becky" should be deleted from the table on the "Example" tab.
I have a question concerning Macros and the Disable/Enable prompt. My boss has a spreadsheet which has been used for years and he recently wanted to and did remove the macros from the spreadsheet (they were no longer necessary), but the disable/enable prompt still appears when the spreadsheet is opened. I replicated this in a test spreadsheet with a simple insert line macro and received the same results. Is there a way to remove the macros and the disable/enable prompt once they are removed? I know about setting the security to low to not see the prompt, but I would think that once the macros are deleted, the prompt should not appear any more.
Complete List of People in Column AA. Partial lists of these same people in columns A, C, E, G, I, K. Goal: Once I put that persons name in A, C, E, G, I, K, I would like it to be deleted from Column AA.
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
I want a macro in one worksheet to run when any cell (in a given range)on a different worksheet (dataentry) is updated. I have spent along time trying to make it work with no avail. The code I use to start my macro is as follows.
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Cells.Count <> 1 Then Exit Sub
If Target(1, 1).Address = "dataentry!H5:IV72" Then If Not Intersect(Target(1, 1), Range("dataentry!H5:IV72")) Is Nothing Then
On Error Resume Next Application.EnableEvents = False
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.
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.
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.
I recently downloaded a macro which came with it's own button on it's own toolbar. (I can't remember the developer, but it's called Multihide and simplifies the hiding and unhiding of worksheets).
Now, I've copied the button onto my own toolbar, and tried deleting the toolbar (by the usual method - Cursor over toolbar, R-Click, Customise, highlight toolbar name, delete) which came with the macro, and although it at first looks as though it's gone, when I next restart Excel, it's there again. I find I can't delete the button from the toolbar either, nor delete the whole toolbar.
I have a spreadsheet that has a formula placed from cells B21 through to AT21. This formula is present in the sheet 95% of the time, but occassionally the user has to enter his/her own value in one of the cells.
How can I check or the user be reminded that he/she has deleted a formula and replaced it with a user defined value. ie a message box(only as a warning) to be displayed just before the workbook is printed. The user should be able to acknowledge the message displayed and carry on.
While making a spreadsheet, I somehow deleted a much needed column. I didn't notice this until after I had made several changes and 'saved as' many times. Is there any way to retrieve this data? I'm not tech-savvy.
Here is the above link. Am looking at a button which saves whatever is the temp worksheet row in the customers worksheet. The temp worksheet basically takes the data from the Quotations worksheet and places it in a row.
I have a worksheet where I've deleted data in cells and rows. I am left with alternating rows of data and blank rows however a macro that I've been running to delete blank rows does not work on some of the rows.
To delete the data I used the Find and Replace feature and it seems that afterward the cells where this data was is now somehow marked as not completely empty. It appears empty but if I use the Control-Right Arrow combination from Column A, it skips over some cells but stops on a cell that used to contain data. If I press the Delete key it clears the cell completely and if I do that on all the cells the Ctrl-Right Arrow stops on until the end of the row, the macro works on that row...but not the next row of seemingly empty cells.
It's not spaces and there's no apostrophes and the cells are all formatted as General (Number Style) and Normal (Styles). I've even copied the format of a row of all deleted cells but that still does not completely clean out the "empty" cells. I've also run the Inspect Document command to remove what may be there but same results.
Is there something I can do to locate and remove this mysterious data?