Hi guys
I have the following macro which basiclly acts as a refresh button on a read only sheet:
The sheet is read only as it is used by many people and it prevents them damaging the sheet. The sheet is updated regularly and as many people who use the sheet have little excel knowledge a refresh button was required. The macro is attached to a button that when clicked, it closes the sheet, then reopens it meaning any updates I add to the sheet can then be seen by everyone else once they click the button - much like 'Refresh'.
So, the code above works fine. Click the button, the sheet closes, 5 seconds later reopens. However, when the sheet reopens, any other excel sheets that are open seem to be at the front and the sheet that has been 'reopened' is behind them. Is there anything I can do to make the macro not only close and reopen the sheet, but when it does reopen, bring it to the front so that it is visible straight away without having to click Window and then select the appropriate sheet?
Hope this all makes sense. Any help with this would be much appreciated.
EDIT: Just tried this on my computer at home (Excel 2010) and it doesnt seem to be an issue.. Unfortunately we use a much older version at work and it will automatically open all excel sheets in one instance of exce hence i need to macro to bring the sheet to the from after reopening.l.
Bookmarks