Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was recording a macro to delete one of the worksheets in my Excel file
because I create a new one each time for the task at hand. When I "turned on" the recording and carried out the steps, I clicked OK to the prompt to delete the sheet. It doesn't appear to "record" clicking OK because when I ran the macro later, I had to click OK on that prompt. Sheets("filtered").Select ActiveWindow.SelectedSheets.Delete Sheets("Complete List").Select I am creating this macro to automate some tasks and someone else will be running it. My goal is to make it user-friendly so the person will not have to "intervene" and couldn't possibly mess up the steps. I do okay recording macros but am not very experienced with the VBA language. Is there anyway to modify the code to delete the sheet without having the user click OK? Thanks, Marcia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to copy values then delete row for entire sheet | New Users to Excel | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro for sheet delete, very easy | Excel Discussion (Misc queries) | |||
delete record using Macro in excel spreed sheet | Excel Programming | |||
macro to delete a sheet | Excel Programming |