Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello out there, I have some code to open a folder (by following a heperlink
in a cell). For some bizarre reason (and only just started happening recently) I get a warning that some folders may contain viruses and do I really want to open this folder? I have to press "OK". Having displayalerts = false does nothing in this instance. Is there another displayalerts type of command that will "OK" this automatically please? Regards, Brett Current code: Sub A_OPENFOLDER() Application.DisplayAlerts = False Range("J50").Hyperlinks(1).Follow NewWindow:=False, AddHistory:=False Application.DisplayAlerts = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Alerts | Excel Discussion (Misc queries) | |||
Inputbox Location on Screen. Can you code it to popup lower on the screen ? | Excel Programming | |||
alerts | Excel Worksheet Functions | |||
alerts | Excel Programming | |||
How to copy data from excel to power point screen by screen? | Excel Programming |