Thread
:
recording macro to delete sheet
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
recording macro to delete sheet
glad to help
--
Don Guillett
SalesAid Software
"Marcia" wrote in message
...
Thanks for the help.
Marcia
"Don Guillett" wrote in message
...
try
Sub deleteselectedsheet()
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True
End Sub
--
Don Guillett
SalesAid Software
"Marcia" wrote in message
...
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]