Need to write refresh macro

johnandbeth

Board Regular
Joined
Apr 8, 2002
Messages
168
How would I write a macro that would use the "refresh" button from the Web toolbar, when asked if you want to close/reopen the workbook, it automatically clicks "yes"?

Thanks!
Beth
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,113,920
Messages
5,545,029
Members
410,647
Latest member
bernardazar
Top