#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GLS GLS is offline
external usenet poster
 
Posts: 8
Default Excell Macros

I have set up a macro to automate the refreshing of reports based on pivot
tables linked to Access queries. How can I:

1. Get the date to show the last time the macro was run?

2. Part of the macro involves deleting a worksheet and replacing it with
current data - how can I suppress the message that asks me to confirm I want
to delete the worksheet?

Thanks in advance.

GLS
--
GLS
Reply
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
Strip workbook of macros, VBA, MS Query, etc. Paul Kraemer Excel Discussion (Misc queries) 4 September 7th 06 01:30 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
how do I run excel 4.0 macros on excel 2000 RodolfoDallas Excel Discussion (Misc queries) 1 March 12th 06 03:14 AM
saving with macros in excell wullie anderson Excel Discussion (Misc queries) 1 September 21st 05 07:01 PM
lable ranges in Excell david Excel Discussion (Misc queries) 2 February 2nd 05 11:26 PM


All times are GMT +1. The time now is 02:18 AM.

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

About Us

"It's about Microsoft Excel"