Posted to microsoft.public.excel.programming

John[_46_] John[_46_] is offline

external usenet poster

Posts: 7

Code to not display delete sheet alerts

I am trying to run code in Access to delete sheets in
Excel. I do not want the alerts to pop up that I am
deleting sheets. I thought the syntax
was "WorkbookName".displayalerts = false. When I run it
though VBA does not know it as a valid command. Does
anyone know the right syntax??

Thanks,
John

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
Delete code	chrisnsmith	Excel Discussion (Misc queries)	4	March 8th 09 01:10 AM
delete code keeps going and coing	Wanna Learn	Excel Discussion (Misc queries)	5	September 2nd 08 11:02 PM
Display Alerts	MarkN	Excel Discussion (Misc queries)	0	June 8th 06 03:13 AM
How can I disable system alerts (deleting a sheet for example)?	andriil	Excel Discussion (Misc queries)	16	December 17th 05 03:37 PM
What is the VBA code to delete a sheet without warning message?	[email protected]	Excel Discussion (Misc queries)	2	August 9th 05 04:16 PM

All times are GMT +1. The time now is 09:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us