Menu

recording macro to delete sheet

Search this Thread

Prev

Previous Post

Next Post

Next

#5

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to copy values then delete row for entire sheet	Pyrotoy	New Users to Excel	18	December 9th 08 12:43 AM
My excel macro recorder no longer shows up when recording macro	jack	Excel Discussion (Misc queries)	3	February 5th 07 08:22 PM
Macro for sheet delete, very easy	comotoman	Excel Discussion (Misc queries)	1	October 11th 05 11:19 PM
delete record using Macro in excel spreed sheet	Lillian[_3_]	Excel Programming	47	December 3rd 03 04:06 PM
macro to delete a sheet	MoiraGunn	Excel Programming	2	September 3rd 03 06:11 AM

All times are GMT +1. The time now is 11:00 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement