LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default recording macro to delete sheet

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
Search this Thread:

Advanced Search
Display Modes

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 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"