How to close popup

[ppyxl]

Hi, guys,

I do not want to see the pop up windows saying----there r lots of
information on the clipboard. Do you want to be able to paste this into
another program later (Yes or No or Cancel) -

is there code for stoping them from poping up ??? Thanks!

 

[Guest]

Application.cutcopymode = False

executed before closing the workbook will avoid the message.

You can also do

application.Displayalerts = False
' close the workbook
Application.DisplayAlerts = True

 

[ppyxl]

It works in excel. thanks!

* D o y o u k n o w i n a c c e s s , h o w t o c l o s
e p o p u p w i n d o w s a s w e l l ? *

Thanks

 

[ducky]

* D o y o u k n o w i n a c c e s s , h o w t o c l o s
e p o p u p w i n d o w s a s w e l l ? *

in access VBA you would use 'DoCmd.SetWarnings (False)'

 

[ppyxl]

how does vba use in access